If the position is AM and the league is larger than 7.0, what is the total R number?
CREATE TABLE table (r VARCHAR, position VARCHAR, AM VARCHAR, league VARCHAR)
SELECT COUNT(r) FROM table WHERE position = AM AND league > 7.0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table (r VARCHAR, position VARCHAR, AM VARCHAR, league VARCHAR) Question: If the position is AM and the league is larger than 7.0, what is the total R number? [/INST] SELECT COUNT(r) FROM table WHERE position = AM AND league > 7.0 </s>