CREATE TABLE manager_award (player_id VARCHAR2)
CREATE TABLE player (name_first VARCHAR2, name_last VARCHAR2, player_id VARCHAR2)

What are the manager's first name, last name and id who won the most manager award?
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
SELECT "T1"."name_first", "T1"."name_last", "T2"."player_id" FROM "player" "T1" JOIN "manager_award" "T2" ON "T1"."player_id" = "T2"."player_id" GROUP BY "T2"."player_id" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY