Table: rugby_match_stats
Columns: date
venue
opponent
result
competition

Question: When did they play against Wales?
SQL: SELECT "date" FROM rugby_match_stats WHERE "opponent" = 'wales'

Question: What was the result on 29/09/07?
SQL: SELECT "result" FROM rugby_match_stats WHERE "date" = '29/09/07'

Question: What was the competition on 25/08/07?
SQL: SELECT "competition" FROM rugby_match_stats WHERE "date" = '25/08/07'