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

Question: How many FA Trophy has a Total larger than 17 and a Player of david gamble and a League Cup larger than 0?
SQL: SELECT COUNT("fa_trophy") FROM football_stats_1993_94 WHERE "total" > 17 AND "player" = 'david gamble' AND "league_cup" > 0

Question: Which League Cup that has a Total of 19 and a League smaller than 15?
SQL: SELECT AVG("league_cup") FROM football_stats_1993_94 WHERE "total" = 19 AND "league" < 15

Question: How many FA Trophy that have a Player of paul dobson, and a League Cup smaller than 2?
SQL: SELECT COUNT("fa_trophy") FROM football_stats_1993_94 WHERE "player" = 'paul dobson' AND "league_cup" < 2