Which Tournament has a Surface of hard, and a Date of 24 september 2011?
CREATE TABLE table_name_40 (tournament VARCHAR, surface VARCHAR, date VARCHAR)
SELECT tournament FROM table_name_40 WHERE surface = "hard" AND date = "24 september 2011"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (tournament VARCHAR, surface VARCHAR, date VARCHAR) Question: Which Tournament has a Surface of hard, and a Date of 24 september 2011? [/INST] SELECT tournament FROM table_name_40 WHERE surface = "hard" AND date = "24 september 2011" </s>