Table: player_stats
Columns: p
player
league
scottish_cup
league_cup
challenge_cup
total

Question: How many points did player 7 score in the challenge cup?
SQL: SELECT COUNT("challenge_cup") FROM player_stats WHERE "p" = 7

Question: What is Kris doolan's league number?
SQL: SELECT COUNT("league") FROM player_stats WHERE "player" = 'Kris Doolan'

Question: What is bryan hodge's player number
SQL: SELECT COUNT("p") FROM player_stats WHERE "player" = 'Bryan Hodge'

Question: What was the lowest number of points scored in the league cup?
SQL: SELECT MIN("league_cup") FROM player_stats