When the club is flamengo in the 2009 season, and they scored more than 0 goals, what's the sum of the Apps?
CREATE TABLE table_name_30 (apps INTEGER, goals VARCHAR, club VARCHAR, season VARCHAR)
SELECT SUM(apps) FROM table_name_30 WHERE club = "flamengo" AND season = "2009" AND goals > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_30 (apps INTEGER, goals VARCHAR, club VARCHAR, season VARCHAR) Question: When the club is flamengo in the 2009 season, and they scored more than 0 goals, what's the sum of the Apps? [/INST] SELECT SUM(apps) FROM table_name_30 WHERE club = "flamengo" AND season = "2009" AND goals > 0 </s>