반응형
SELECT bb.name as name FROM (SELECT count(id) as vv, candidateId FROM Vote Group BY candidateId Order By vv desc limit 1) aa JOIN Candidate bb on aa.candidateId = bb.id반응형
'sql문제' 카테고리의 다른 글
| 610. Triangle Judgement (0) | 2022.09.05 |
|---|---|
| 570. Managers with at Least 5 Direct Reports (0) | 2022.09.04 |
| 550. Game Play Analysis IV (0) | 2022.09.03 |