Table: player_stats_83
Columns: name
championship
league_cup
fa_cup
total

Question: What is the highest league up with less than 3 championships, a total less than 2, and a FA cup larger than 0?
SQL: SELECT MAX("league_cup") FROM player_stats_83 WHERE "championship" < 3 AND "total" < 2 AND "fa_cup" > 0

Question: What is the average total for less than 1 championship?
SQL: SELECT AVG("total") FROM player_stats_83 WHERE "championship" < 1

Question: What i the total number of championships less than 2, and a league cup larger than 1?
SQL: SELECT COUNT("total") FROM player_stats_83 WHERE "championship" < 2 AND "league_cup" > 1