Schema: CREATE TABLE player (birth_country VARCHAR, bats VARCHAR)
Question: How many players born in USA are right-handed batters? That is, have the batter value 'R'.
SQL: SELECT COUNT(*) FROM player WHERE birth_country = 'USA' AND bats = 'R'