Table: rugby_player_stats
Columns: player
position
tries
goals
points

Question: Which player has 0 goals, 1 tries, 4 points, and plays in the Prop position?
SQL: SELECT "player" FROM rugby_player_stats WHERE "goals" = 0 AND "tries" = 1 AND "points" = 4 AND "position" = 'prop'

Question: What is the average number of Tries for Nathan McAvoy?
SQL: SELECT AVG("tries") FROM rugby_player_stats WHERE "player" = 'nathan mcavoy'

Question: What is the average number of Tries with less than 28 Points for Mike Forshaw?
SQL: SELECT AVG("tries") FROM rugby_player_stats WHERE "player" = 'mike forshaw' AND "points" < 28