user: ### NOW ANSWER:
Question: What is the weekly rank with an air date is November 12, 2007?
Columns: ['#', 'Episode', 'Air Date', 'Rating', 'Share', '18–49 (Rating/Share)', 'Viewers (m)', 'Weekly Rank']
Types: ['real', 'text', 'text', 'text', 'real', 'text', 'text', 'real']
Sample row: [1.0, '"A Love of a Lifetime"', 'September 24, 2007', '5.8', 9.0, '3.5/9', '9.16', 43.0]
SQL:

assistant: SELECT "Weekly Rank" FROM "Table" WHERE "Air Date" = 'November 12, 2007';