Untitled

 avatar
user_8556937499
plain_text
2 years ago
375 B
0
Indexable
Never
SELECT DISTINCT(submission_date), 
(SELECT COUNT(DISTINCT(hacker_id)) FROM Submissions WHERE submission_date=s.submission_date),
(SELECT s2.hacker_id, h.name FROM Submissions s2, Hackers h WHERE s2.hacker_id=h.hacker_id AND s2.submission_date=s.submission_date GROUP BY s2.hacker_id ORDER BY COUNT(*) DESC, s2.hacker_id ASC) FROM Submissions s ORDER BY submission_date ASC;