What are the ids of 3 players that won the most awards?
SELECT 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
ids of 3 players that won the most awards refers to selecting player_id from a JOIN between player and player_award tables, grouping by player_id and ordering by COUNT(*) DESC with a LIMIT of 3;