How many Malaysia Cups have 0 for the total with a league greater than 0?
CREATE TABLE table_name_2 (malaysia_cup VARCHAR, total VARCHAR, league VARCHAR)
SELECT COUNT(malaysia_cup) FROM table_name_2 WHERE total = 0 AND league > 0
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_2 (malaysia_cup VARCHAR, total VARCHAR, league VARCHAR) Question: How many Malaysia Cups have 0 for the total with a league greater than 0? [/INST] SELECT COUNT(malaysia_cup) FROM table_name_2 WHERE total = 0 AND league > 0 </s>