Top Competitors(连接查询)

题意：https://www.hackerrank.com/challenges/full-score/problem

select hackers.hacker_id, hackers.name from submissions inner join challenges
								on submissions.challenge_id = challenges.challenge_id
						  inner join difficulty 
								on challenges.difficulty_level = difficulty.difficulty_level
						  inner join hackers
								on submissions.hacker_id = hackers.hacker_id
		 where submissions.score = difficulty.score
         group by hackers.hacker_id, hackers.name
         having count(hackers.hacker_id) > 1
         order by count(hackers.hacker_id) desc, hackers.hacker_id;