Table: rugby_pro_d2_stats
Columns: club
total_points
bonus_points
match_points
games
drawn
lost
points_for
points_against
diff

Question: What is the value of match points when the points for is 570?
SQL: SELECT "match_points" FROM rugby_pro_d2_stats WHERE "points_against" = '570'

Question: What is the amount of match points for a club that lost 18 and has 11 bonus points?
SQL: SELECT "match_points" FROM rugby_pro_d2_stats WHERE "lost" = '18' AND "bonus_points" = '11'

Question: What is the diff for a club that has a value of 662 for points for?
SQL: SELECT "diff" FROM rugby_pro_d2_stats WHERE "points_for" = '662'

Question: What is the number of games for a club that has a value of 595 for points for?
SQL: SELECT "games" FROM rugby_pro_d2_stats WHERE "points_for" = '595'

Question: What is the number of games for a club that has 34 match points?
SQL: SELECT "games" FROM rugby_pro_d2_stats WHERE "match_points" = '34'

Question: How many bonus points did the Colomiers earn?
SQL: SELECT "bonus_points" FROM rugby_pro_d2_stats WHERE "club" = 'colomiers'