We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
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
Top Competitors
You are viewing a single comment's thread. Return to all comments →
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