Who are the managers that have won the manager award?
select t1.name_first, t1.name_last from player as t1 join manager_award as t2 on t1.player_id = t2.player_id
How many times did each manager get this award?
select t1.name_first, t1.name_last, count(*) from player as t1 join manager_award as t2 on t1.player_id = t2.player_id group by t2.player_id
Who won the most times?
select t1.name_first, t1.name_last, count(*) from player as t1 join manager_award as t2 on t1.player_id = t2.player_id group by t2.player_id order by count(*) desc limit 1
Please give their full name and id.
select t1.name_first, t1.name_last, t2.player_id from player as t1 join manager_award as t2 on t1.player_id = t2.player_id group by t2.player_id order by count(*) desc limit 1;