Table: player_stats_86_87
Columns: player
club
league
fa_cup
fa_trophy
league_cup
total

Question: What is the average total with 1 FA cup and more than 0 FA trophies?
SQL: SELECT AVG("total") FROM player_stats_86_87 WHERE "fa_cup" = 1 AND "fa_trophy" > 0

Question: Which club had more than 2 FA trophies and more than 2 FA cups?
SQL: SELECT "club" FROM player_stats_86_87 WHERE "fa_trophy" > 2 AND "fa_cup" > 2