Can you tell me the lowest Cap Number that has the Date of 8 february 2009, and the Shirt Number larger than 19?
CREATE TABLE table_name_96 (cap_number INTEGER, date VARCHAR, shirt_number VARCHAR)
SELECT MIN(cap_number) FROM table_name_96 WHERE date = "8 february 2009" AND shirt_number > 19
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_96 (cap_number INTEGER, date VARCHAR, shirt_number VARCHAR) Question: Can you tell me the lowest Cap Number that has the Date of 8 february 2009, and the Shirt Number larger than 19? [/INST] SELECT MIN(cap_number) FROM table_name_96 WHERE date = "8 february 2009" AND shirt_number > 19 </s>