Which Total has a Rank smaller than 3, and a County of cork?
CREATE TABLE table_name_18 (total INTEGER, rank VARCHAR, county VARCHAR)
SELECT MIN(total) FROM table_name_18 WHERE rank < 3 AND county = "cork"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_18 (total INTEGER, rank VARCHAR, county VARCHAR) Question: Which Total has a Rank smaller than 3, and a County of cork? [/INST] SELECT MIN(total) FROM table_name_18 WHERE rank < 3 AND county = "cork" </s>