574. Winning Candidate

SELECT Name
FROM Candidate c
INNER JOIN (SELECT CandidateId
FROM Vote
GROUP BY CandidateId
ORDER BY COUNT(*) DESC
LIMIT 1) AS w
ON c.id = w.CandidateId;

posted @ 2018-12-23 02:44  yuesi  阅读(112)  评论(0编辑  收藏  举报