Table: swimmer_record
Columns: event
time
venue
date
notes

Question: Which venue has a note of AM?
SQL: SELECT "venue" FROM swimmer_record WHERE "notes" = 'am'

Question: What is the time associated with August 16, 2008?
SQL: SELECT "time" FROM swimmer_record WHERE "date" = 'august 16, 2008'

Question: Which event was held in Beijing?
SQL: SELECT "event" FROM swimmer_record WHERE "venue" = 'beijing'

Question: For a venue of Rome on July 30, 2009, what are the notes?
SQL: SELECT "notes" FROM swimmer_record WHERE "venue" = 'rome' AND "date" = 'july 30, 2009'