Table: rugby_stats_23
Columns: round
home_team
win_loss
score
opposition
location

Question: What is the score when the opposition is mid canterbury?
SQL: SELECT "score" FROM rugby_stats_23 WHERE "opposition" = 'Mid Canterbury'

Question: what is the home team when the opposition is east coast?
SQL: SELECT "home_team" FROM rugby_stats_23 WHERE "opposition" = 'East Coast'

Question: What is the home team when the opposition is wairarapa bush?
SQL: SELECT "home_team" FROM rugby_stats_23 WHERE "opposition" = 'Wairarapa Bush'

Question: what is the home team when the round # is round 1?
SQL: SELECT "home_team" FROM rugby_stats_23 WHERE "round" = 'Round 1'

Question: Who is the opposition when the score is 37 - 28?
SQL: SELECT "opposition" FROM rugby_stats_23 WHERE "score" = '37 - 28'

Question: What is the location when the opposition is mid canterbury?
SQL: SELECT "location" FROM rugby_stats_23 WHERE "opposition" = 'Mid Canterbury'