CREATE TABLE table_name_9 (total NUMBER, premier_league VARCHAR2, league_cup VARCHAR2)

How many totals have a Premier League smaller than 6, and a League Cup larger than 0?
SELECT SUM(total) FROM table_name_9 WHERE premier_league < 6 AND league_cup > 0
SELECT SUM("total") FROM "table_name_9" WHERE "league_cup" > 0 AND "premier_league" < 6