Top Competitors(连接查询)

最新推荐文章于 2023-05-16 08:00:00 发布

kgduu

最新推荐文章于 2023-05-16 08:00:00 发布

阅读量265

点赞数

分类专栏： OJ

本文链接：https://blog.csdn.net/xiexingshishu/article/details/80156221

版权

OJ 专栏收录该内容

986 篇文章 1 订阅

订阅专栏

题意：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;