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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: How many Malaysia Cups have 0 for the total with a league greater than 0? ### Input: CREATE TABLE table_name_2 (
    malaysia_cup VARCHAR,
    total VARCHAR,
    league VARCHAR
) ### Response: SELECT COUNT(malaysia_cup) FROM table_name_2 WHERE total = 0 AND league > 0