Table: player_stats_97
Columns: name
premier_league
league_cup
fa_cup
uefa_cup
total

Question: How much Premier League has an FA Cup of 0, and a Total of 1, and a UEFA Cup larger than 1?
SQL: SELECT SUM("premier_league") FROM player_stats_97 WHERE "fa_cup" = 0 AND "total" = 1 AND "uefa_cup" > 1

Question: How many totals have a Premier League smaller than 6, and a League Cup larger than 0?
SQL: SELECT SUM("total") FROM player_stats_97 WHERE "premier_league" < 6 AND "league_cup" > 0

Question: Which FA Cup has a Total smaller than 1?
SQL: SELECT AVG("fa_cup") FROM player_stats_97 WHERE "total" < 1