How many players have won player awards?
select count(*) from player as t1 join player_award as t2 on t1.player_id = t2.player_id
Please list their full names.
select t1.name_first, t1.name_last from player as t1 join player_award as t2 on t1.player_id = t2.player_id group by t1.player_id
Among them, who won the most player awards? List their full name and id.
select t1.name_first, t1.name_last, t1.player_id from player as t1 join player_award as t2 on t1.player_id = t2.player_id group by t1.player_id order by count(*) desc limit 1;
How about top 3?
select t1.name_first, t1.name_last, t1.player_id from player as t1 join player_award as t2 on t1.player_id = t2.player_id group by t1.player_id order by count(*) desc limit 3;