CREATE TABLE all_star (player_id VARCHAR)
CREATE TABLE player (name_first VARCHAR, name_last VARCHAR, player_id VARCHAR)

What are the first name, last name and id of the player with the most all star game experiences? Also list the count.
SELECT T1.name_first, T1.name_last, T1.player_id, COUNT(*) FROM player AS T1 JOIN all_star AS T2 ON T1.player_id = T2.player_id GROUP BY T1.player_id ORDER BY COUNT(*) DESC LIMIT 1
SELECT "T1"."name_first", "T1"."name_last", "T1"."player_id", COUNT(*) FROM "player" AS "T1" JOIN "all_star" AS "T2" ON "T1"."player_id" = "T2"."player_id" GROUP BY "T1"."player_id" ORDER BY COUNT(*) DESC NULLS LAST LIMIT 1