Table: flames_season_8
Columns: date
opponent
venue
result
attendance
competition

Question: How many people attended the game that lost 2-4 and the date was higher than 15?
SQL: SELECT COUNT("attendance") FROM flames_season_8 WHERE "result" = 'lost 2-4' AND "date" > 15

Question: What kind of competition had an attendance of more than 914 people and the Wightlink Raiders as an opponent?
SQL: SELECT "competition" FROM flames_season_8 WHERE "attendance" > 914 AND "opponent" = 'wightlink raiders'

Question: How many people attended the away league competition with a date of 22?
SQL: SELECT "attendance" FROM flames_season_8 WHERE "competition" = 'league' AND "venue" = 'away' AND "date" = 22