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;
https://github.com/qixing810/leetcode_database
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;