user: ### NOW ANSWER:
Question: what is the average rating when the air date is November 23, 2007?
Columns: ['Episode', 'Air date', 'Rating', 'Share', '18-49 (Rating/Share)', 'Viewers (m)', 'Rank (timeslot)']
Types: ['text', 'text', 'real', 'real', 'text', 'real', 'text']
Sample row: ['"Welcome to the Club"', 'October 12, 2007', 7.3, 13.0, '2.5/8', 10.82, '#1']
SQL:

assistant: SELECT AVG("Rating") FROM "Table" WHERE "Air date" = 'November 23, 2007';