Untitled
user_8556937499
plain_text
4 years ago
300 B
5
Indexable
SELECT hacker_id, name FROM Hackers WHERE hacker_id IN (SELECT s.hacker_id FROM Submissions s, Challenges c, Difficulty d WHERE s.challenge_id=c.challenge_id AND c.difficulty_level=d.difficulty_level AND s.score=d.score GROUP BY s.hacker_id HAVING COUNT(*)>1 ORDER BY COUNT(*) DESC, s.hacker_id ASC);
Editor is loading...