How many players born in USA are right-handed batters? That is, have the batter value 'R'.
CREATE TABLE player (birth_country VARCHAR, bats VARCHAR)
SELECT COUNT(*) FROM player WHERE birth_country = 'USA' AND bats = 'R'
<s>[INST] Write mssql query to answer the following question given the database schema. 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'. [/INST] SELECT COUNT(*) FROM player WHERE birth_country = 'USA' AND bats = 'R' </s>