How many players have participated in all star games?
select count(*) from player as t1 join all_star as t2 on t1.player_id = t2.player_id
Among these players, how many times did they participate in all star game?
select t1.name_first, t1.name_last, count(*) from player as t1 join all_star as t2 on t1.player_id = t2.player_id group by t1.player_id
Could you please give the top 10 players that have the most all star experience?
select t1.name_first, t1.name_last, 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 10
Please give me the information of the top one.
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