Table: flames_season
Columns: date
opponent
venue
result
attendance
competition
man_of_the_match

Question: On what date was the venue Away and the result was lost 6-4 (lost 9-7 on agg)?
SQL: SELECT "date" FROM flames_season WHERE "venue" = 'away' AND "result" = 'lost 6-4 (lost 9-7 on agg)'

Question: What was the result on the 26th?
SQL: SELECT "result" FROM flames_season WHERE "date" = '26th'

Question: What was the date when the opponent was Sheffield Scimitars and the venue was Home?
SQL: SELECT "date" FROM flames_season WHERE "opponent" = 'sheffield scimitars' AND "venue" = 'home'

Question: Who was the Man of the Match when the opponent was Milton Keynes Lightning and the venue was Away?
SQL: SELECT "man_of_the_match" FROM flames_season WHERE "opponent" = 'milton keynes lightning' AND "venue" = 'away'

Question: What competition was held on the 26th?
SQL: SELECT "competition" FROM flames_season WHERE "date" = '26th'

Question: What was the date when the attendance was n/a and the Man of the Match was unknown?
SQL: SELECT "date" FROM flames_season WHERE "attendance" = 'n/a' AND "man_of_the_match" = 'unknown'