Table: harold_fleming_football_stats
Columns: season
team
league_apps
league_goals
cup_apps
cup_goals

Question: How many cop apps in the season with fewer than 12 league apps?
SQL: SELECT SUM("cup_apps") FROM harold_fleming_football_stats WHERE "league_apps" < 12

Question: What season saw 6 cup apps and 5 cup goals?
SQL: SELECT "season" FROM harold_fleming_football_stats WHERE "cup_apps" = 6 AND "cup_goals" = 5

Question: How many league apps in the season with more than 2 cup goals and more than 6 cup apps?
SQL: SELECT SUM("league_apps") FROM harold_fleming_football_stats WHERE "cup_goals" > 2 AND "cup_apps" > 6

Question: How many cup goals for the season with more than 34 league apps?
SQL: SELECT AVG("cup_goals") FROM harold_fleming_football_stats WHERE "league_apps" > 34

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

Question: How many cup apps for the season where there are more than 10 league goals and 23 league apps?
SQL: SELECT "cup_apps" FROM harold_fleming_football_stats WHERE "league_goals" > 10 AND "league_apps" = 23