CREATE TABLE table_name_30 (league VARCHAR2, total NUMBER)

What's the total for a league cup less than 1?
SELECT COUNT(league) AS Cup FROM table_name_30 WHERE total < 1
SELECT COUNT("league") AS "Cup" FROM "table_name_30" WHERE "total" < 1