CREATE TABLE table_name_78 (cup_goals INT, league_goals VARCHAR, league_apps VARCHAR, cup_apps VARCHAR)

How many cup goals in the season with more than 5 league apps, 1 cup apps and fewer than 4 league goals?
SELECT SUM(cup_goals) FROM table_name_78 WHERE league_apps > 5 AND cup_apps = 1 AND league_goals < 4
SELECT SUM("cup_goals") FROM "table_name_78" WHERE "cup_apps" = 1 AND "league_apps" > 5 AND "league_goals" < 4