Table: player_stats_23
Columns: player
league
scottish_cup
league_cup
challenge_cup
total

Question: What is the lowest league for a less than 0 league cup?
SQL: SELECT MIN("league") FROM player_stats_23 WHERE "league_cup" < 0

Question: What is the lowest Scottish cup with a challenge cup less than 1, and 0 league cups, and player Kris Doolan?
SQL: SELECT MIN("scottish_cup") FROM player_stats_23 WHERE "challenge_cup" < 1 AND "league_cup" = 0 AND "player" = 'kris doolan'

Question: What is the sum for the Scottish cup that has player Damon Gray, and more than 1 league?
SQL: SELECT SUM("scottish_cup") FROM player_stats_23 WHERE "player" = 'damon gray' AND "league" > 1

Question: What was the average league with Kris Doolan and a total less than 5?
SQL: SELECT AVG("league") FROM player_stats_23 WHERE "player" = 'kris doolan' AND "total" < 5