Table: rugby_stats_11
Columns: club
played
won
drawn
lost
points_for
points_against
tries_for
points

Question: Nantyglo RFC had 546 points for and how many points?
SQL: SELECT "points" FROM rugby_stats_11 WHERE "points_for" = '546'

Question: What club had 523 points against? 
SQL: SELECT "club" FROM rugby_stats_11 WHERE "points_against" = '523'

Question: What club has 536 points for?
SQL: SELECT "club" FROM rugby_stats_11 WHERE "points_for" = '536'

Question: How many clubs had 7 wins? 
SQL: SELECT COUNT("club") FROM rugby_stats_11 WHERE "won" = '7'

Question: What club had 404 points against? 
SQL: SELECT "club" FROM rugby_stats_11 WHERE "points_against" = '404'

Question: Risca RFC has 54 tries for and how many draws? 
SQL: SELECT "drawn" FROM rugby_stats_11 WHERE "tries_for" = '54'