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
How about in 1998?
select count(*) from player as t1 join all_star as t2 on t1.player_id = t2.player_id where year = 1998
Please list the first and last names of these players.
select name_first, name_last from player as t1 join all_star as t2 on t1.player_id = t2.player_id where year = 1998