# $574. 当选者
# https://leetcode-cn.com/problems/winning-candidate/

# SQL架构
Create table If Not Exists Candidate (id int, name varchar(255));
Create table If Not Exists Vote (id int, candidateId int);
Truncate table Candidate;
insert into Candidate (id, name) values ('1', 'A');
insert into Candidate (id, name) values ('2', 'B');
insert into Candidate (id, name) values ('3', 'C');
insert into Candidate (id, name) values ('4', 'D');
insert into Candidate (id, name) values ('5', 'E');
Truncate table Vote;
insert into Vote (id, candidateId) values ('1', '2');
insert into Vote (id, candidateId) values ('2', '4');
insert into Vote (id, candidateId) values ('3', '3');
insert into Vote (id, candidateId) values ('4', '2');
insert into Vote (id, candidateId) values ('5', '5');

# Write your MySQL query statement below
select
    c.name
from
    (
        select
            candidateId as id
        from
            Vote
        group by
            candidateId
        order by
            count(id) desc
        limit
            1
    ) tmp
    join Candidate c on tmp.id = c.id;

# clean-up
drop table Candidate;
drop table Vote;