SQL 문제풀이

leetcode - 574. Winning Candidate

Jerrytwo 2022. 6. 29. 19:53

난이도 : Medium

 

 

SELECT DISTINCT name
FROM Candidate
WHERE id = (
            SELECT candidateId
            FROM Vote
            GROUP BY candidateId
            ORDER BY COUNT(candidateId) DESC
            LIMIT 1
            )

Accepted