Table: footballer_stats_3
Columns: division
league_apps_sub
league_goals
fa_cup_apps_sub
fa_cup_goals
fl_cup_apps_sub
fl_cup_goals
other_apps
other_goals
total_apps_sub
total_goals

Question: What division has the highest FA Cup Goals, but a Total Goal score less than 5, and a Total Apps of 52?
SQL: SELECT MAX("fa_cup_goals") FROM footballer_stats_3 WHERE "total_apps_sub" = '52' AND "total_goals" < 5

Question: What is the average FL Cup Apps, with a FL Cup Goals greater than 0, but a Other Apps less than 0?
SQL: SELECT AVG("fl_cup_apps_sub") FROM footballer_stats_3 WHERE "fl_cup_goals" > 0 AND "other_apps" < 0

Question: What is Division One's total number of FL Cup Goals, with an Other Apps greater than 3, and a FA Cup Goals greater than 0?
SQL: SELECT COUNT("fl_cup_goals") FROM footballer_stats_3 WHERE "division" = 'one' AND "other_apps" > 3 AND "fa_cup_goals" > 0

Question: What is Division One's average Other Apps, with a League Goal less than 1?
SQL: SELECT AVG("other_apps") FROM footballer_stats_3 WHERE "division" = 'one' AND "league_goals" < 1