hi, can you tell me the first and last name for the player with player ID: gomezle01?
select name_first, name_last from player where player_id = "gomezle01"
yes. What is the player's first and last name for player ID: ferreri01?
select name_first, name_last from player where player_id = "ferreri01"
in addition to Rick Ferrell, Lefty Gomez, and player ID gehrilo01, can you tell me the first and last names of the other players participating in 1998 all star game?
select name_first, name_last from player as t1 join all_star as t2 on t1.player_id = t2.player_id where year = 1998 and name_first ! = "Rick" or name_last ! = "Ferrell" intersect select name_first, name_last from player as t1 join all_star as t2 on t1.player_id = t2.player_id where year = 1998 and name_first ! = "Lefty" or name_last ! = "Gomez" intersect select name_first, name_last from player as t1 join all_star as t2 on t1.player_id = t2.player_id where year = 1998 and t1.player_id ! = "gehrilo01"
great. what is the player with player ID gehrilo01 first and last name?
select name_first, name_last from player where player_id = "gehrilo01"