Table: rugby_player_stats
Columns: season
appearance
tries
goals
points

Question: what is the lowest appearance when goals is more than 0?
SQL: SELECT MIN("appearance") FROM rugby_player_stats WHERE "goals" > 0

Question: what is the sum of appearance when goals is more than 0?
SQL: SELECT SUM("appearance") FROM rugby_player_stats WHERE "goals" > 0

Question: what is the average tries for the season 2008 warrington wolves with an appearance more than 7?
SQL: SELECT AVG("tries") FROM rugby_player_stats WHERE "season" = '2008 warrington wolves' AND "appearance" > 7

Question: How many times is tries 0 and appearance less than 0?
SQL: SELECT COUNT("points") FROM rugby_player_stats WHERE "tries" = 0 AND "appearance" < 0