On what date was the Loss by Flanagan (6-7)?
CREATE TABLE table_name_40 (date VARCHAR, loss VARCHAR)
SELECT date FROM table_name_40 WHERE loss = "flanagan (6-7)"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (date VARCHAR, loss VARCHAR) Question: On what date was the Loss by Flanagan (6-7)? [/INST] SELECT date FROM table_name_40 WHERE loss = "flanagan (6-7)" </s>