Table: comets_2008_season
Columns: date
opponent
score
result
record

Question: What was the Result on May 30?
SQL: SELECT "result" FROM comets_2008_season WHERE "date" = 'may 30'

Question: What was the Result on July 24?
SQL: SELECT "result" FROM comets_2008_season WHERE "date" = 'july 24'

Question: What was the Score of the game with a Record of 0-1?
SQL: SELECT "score" FROM comets_2008_season WHERE "record" = '0-1'

Question: What is the Record of the game on June 24?
SQL: SELECT "record" FROM comets_2008_season WHERE "date" = 'june 24'

Question: What is the Date of the game with a Loss and Record of 7-9?
SQL: SELECT "date" FROM comets_2008_season WHERE "result" = 'loss' AND "record" = '7-9'

Question: What is the Record on July 12?
SQL: SELECT "record" FROM comets_2008_season WHERE "date" = 'july 12'