Table: rugby_player_stats_10
Columns: player
tries
goals
field_goals
points

Question: What is the highest Goal for danny williams, with more than 0 Field Goals?
SQL: SELECT MAX("goals") FROM rugby_player_stats_10 WHERE "player" = 'danny williams' AND "field_goals" > 0

Question: What is the average Tries with less than 0 goals?
SQL: SELECT AVG("tries") FROM rugby_player_stats_10 WHERE "goals" < 0

Question: What is the total number of Points with less than 1 tries, and more than 0 goals?
SQL: SELECT COUNT("points") FROM rugby_player_stats_10 WHERE "tries" < 1 AND "goals" > 0