有小伙伴一起刷SQL吗？

yanyi869 发表于 2018-8-31 06:13
一起讨论下这道题？https://www.hackerrank.com/challenges/challenges/problem

我的思路是用union

Mine:

WITH data
AS
(
SELECT c.hacker_id as id, h.name as name, count(c.hacker_id) as counter
FROM Hackers h
JOIN Challenges c on c.hacker_id = h.hacker_id
GROUP BY c.hacker_id, h.name
)

SELECT id,name,counter
FROM data
WHERE
counter=(SELECT max(counter) FROM data)
OR
counter in (SELECT counter FROM data
GROUP BY counter
HAVING count(counter)=1 )
ORDER BY counter desc, id

Fishsh 发表于 2018-9-5 23:19
Mine:

WITH data

赞啊 感谢分享

前辈您好！非常高兴能够认识前辈！我是一名UIUC统计系的博士生，拿到了明年暑假FRL的intern offer，不知道能否请教一下前辈几个问题，非常非常的感谢前辈啊!

一起报名 13861330503