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