user: Question: Which Week has an Air Date of August 2, 2008?
Columns: ['Week', 'Event', 'Air Date', 'Winning team', 'Winners club']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 'Chariot of Champions', 'July 27, 2008', 'Blue Team', 'Hawaiian Luau']
SQL:

assistant: SELECT "Week" FROM "Table" WHERE "Air Date" = 'August 2, 2008';