How many players has the birth country in USA?
select count ( player_id )  from player where birth_country  =  'USA'
count of players = COUNT(player_id); birth country in USA refers to birth_country = 'USA';