How many games were lost when the order was 2nd and the play was more than 13
CREATE TABLE table_name_66 (lost VARCHAR, order VARCHAR, played VARCHAR)
SELECT COUNT(lost) FROM table_name_66 WHERE order = "2nd" AND played > 13
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_66 (lost VARCHAR, order VARCHAR, played VARCHAR) Question: How many games were lost when the order was 2nd and the play was more than 13 [/INST] SELECT COUNT(lost) FROM table_name_66 WHERE order = "2nd" AND played > 13 </s>