In the 2010 season what club has 0 goals and more than 0 Apps?
CREATE TABLE table_name_43 (club VARCHAR, season VARCHAR, goals VARCHAR, apps VARCHAR)
SELECT club FROM table_name_43 WHERE goals = 0 AND apps > 0 AND season = "2010"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_43 (club VARCHAR, season VARCHAR, goals VARCHAR, apps VARCHAR) Question: In the 2010 season what club has 0 goals and more than 0 Apps? [/INST] SELECT club FROM table_name_43 WHERE goals = 0 AND apps > 0 AND season = "2010" </s>