Table: player_stats_06_07
Columns: player
position
premier_league
fa_cup
league_cup
uefa_cup
total

Question: What is the premier league number when the position is forward, and the total is more than 22?
SQL: SELECT COUNT("premier_league") FROM player_stats_06_07 WHERE "position" = 'forward' AND "total" > 22

Question: What is the total when the league cup is less than 1, and the fa cup is less than 1?
SQL: SELECT SUM("total") FROM player_stats_06_07 WHERE "league_cup" < 1 AND "fa_cup" < 1

Question: What is the lowest league cup with a premier League of 1, and the total is less than 5?
SQL: SELECT MIN("league_cup") FROM player_stats_06_07 WHERE "premier_league" = 1 AND "total" < 5

Question: What is the lowest FA Cup when the league cup is 1, and the total is more than 23?
SQL: SELECT MIN("fa_cup") FROM player_stats_06_07 WHERE "league_cup" = 1 AND "total" > 23