Table: player_stats_12
Columns: player
league
scottish_cup
league_cup
challenge_cup
total

Question: What is the average total of player Simon Donnelly, with a Scottish Cup greater than 0?
SQL: SELECT AVG("total") FROM player_stats_12 WHERE "player" = 'simon donnelly' AND "scottish_cup" > 0

Question: What is the Challenge Cup total with a League of 1, Player Simon Storey, and a Total greater than 1?
SQL: SELECT SUM("challenge_cup") FROM player_stats_12 WHERE "league" = 1 AND "player" = 'simon storey' AND "total" > 1

Question: What is the highest total of Player Damon Gray, with a Challenge Cup less than 0?
SQL: SELECT MAX("total") FROM player_stats_12 WHERE "player" = 'damon gray' AND "challenge_cup" < 0

Question: What is the least for Scottish Cup with a Challenge Cup greater than 0, Player Paul Keegan, and League Cup greater than 0?
SQL: SELECT MIN("scottish_cup") FROM player_stats_12 WHERE "challenge_cup" > 0 AND "player" = 'paul keegan' AND "league_cup" > 0

Question: What is the greatest Challenge Cup with a League smaller than 2, Total greater than 2, and a League Cup greater than 1?
SQL: SELECT MAX("challenge_cup") FROM player_stats_12 WHERE "league" < 2 AND "total" > 2 AND "league_cup" > 1

Question: What is the highest Total with a League Cup greater than 0, Player Gary Harkins, and Scottish Cup greater than 0?
SQL: SELECT MAX("total") FROM player_stats_12 WHERE "league_cup" > 0 AND "player" = 'gary harkins' AND "scottish_cup" > 0