Top Competitors

  • + 1 comment

    Plz someone help me ,what's wrong in this query. select a.hacker_id, a.name from hackers a join submissions b on a.hacker_id= b.hacker_id where b.challenge_id in (select a.challenge_id from challenges a join difficulty b on a.difficulty_level=b.difficulty_level) and b.score in (select a.score from difficulty a join challenges b on a.difficulty_level=b.difficulty_level) group by a.hacker_id having count(a.hacker_id)>1 order by count(a.hacker_id) desc, a.hacker_id asc