How much Rank has a Tally of 0-10, and an Opposition of cork?
CREATE TABLE table_name_37 (rank VARCHAR, tally VARCHAR, opposition VARCHAR)
SELECT COUNT(rank) FROM table_name_37 WHERE tally = "0-10" AND opposition = "cork"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_37 (rank VARCHAR, tally VARCHAR, opposition VARCHAR) Question: How much Rank has a Tally of 0-10, and an Opposition of cork? [/INST] SELECT COUNT(rank) FROM table_name_37 WHERE tally = "0-10" AND opposition = "cork" </s>