yes
select birth_country from player
What is the birth state of player aardsda01?
select birth_state from player where player_id = "aardsda01"
What about birth city?
select birth_city from player where player_id = "aardsda01"
yes
select birth_city from player where player_id = "aaronto01"
How many players in the USA have a batter value R?
select count ( * ) from player where birth_country = 'USA' and bats = 'R'
How many with a value R that are dead, died in the USA?
select count ( * ) from player where birth_country = 'USA' and bats = 'R' and death_year < 2019 and death_country = 'USA'
How many with a value R died after the year 2000?
select count ( * ) from player where bats = 'R' and death_year > 2000
What about born after the year 1980?
select count ( * ) from player where bats = 'R' and birth_year > 1980