Table: football_stats_6
Columns: club
played
drawn
lost
points_for
points_against
points_difference
points

Question: How many points did Newport RFC get?
SQL: SELECT "points" FROM football_stats_6 WHERE "club" = 'newport rfc'

Question: What club had a loss of 15?
SQL: SELECT "club" FROM football_stats_6 WHERE "lost" = '15'

Question: When there were 554 points, what was the point difference?
SQL: SELECT "points_difference" FROM football_stats_6 WHERE "points_for" = '554'

Question: When there were 767 points, what was the point difference?
SQL: SELECT "points_difference" FROM football_stats_6 WHERE "points_against" = '767'

Question: What club had a points difference of -24?
SQL: SELECT "club" FROM football_stats_6 WHERE "points_difference" = '-24'