What club had over 0 goals in 2011?
CREATE TABLE table_name_40 (club VARCHAR, goals VARCHAR, season VARCHAR)
SELECT club FROM table_name_40 WHERE goals > 0 AND season = "2011"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_40 (club VARCHAR, goals VARCHAR, season VARCHAR) Question: What club had over 0 goals in 2011? [/INST] SELECT club FROM table_name_40 WHERE goals > 0 AND season = "2011" </s>