CREATE TABLE table_name_2 (malaysia_cup VARCHAR2, total VARCHAR2, league VARCHAR2)

How many Malaysia Cups have 0 for the total with a league greater than 0?
SELECT COUNT(malaysia_cup) FROM table_name_2 WHERE total = 0 AND league > 0
SELECT COUNT("malaysia_cup") FROM "table_name_2" WHERE "league" > 0 AND "total" = 0