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

Question: Which League has a FA Cup larger than 0, and a Player of simon read, and a League Cup larger than 1?
SQL: SELECT MIN("league") FROM player_stats_60 WHERE "fa_cup" > 0 AND "player" = 'simon read' AND "league_cup" > 1

Question: What kind of Total that has a League Cup larger than 3, and a League smaller than 16?
SQL: SELECT COUNT("total") FROM player_stats_60 WHERE "league_cup" > 3 AND "league" < 16

Question: Which League has a League Cup smaller than 0?
SQL: SELECT MIN("league") FROM player_stats_60 WHERE "league_cup" < 0

Question: Which League has a Total smaller than 16, a Player of ken mckenna and a League Cup larger than 0?
SQL: SELECT MAX("league") FROM player_stats_60 WHERE "total" < 16 AND "player" = 'ken mckenna' AND "league_cup" > 0

Question: Which FA Cup that has a League Cup larger than 3 and a League smaller than 16?
SQL: SELECT AVG("fa_cup") FROM player_stats_60 WHERE "league_cup" > 3 AND "league" < 16