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

assistant: SELECT SUM("Share") FROM "Table" WHERE "Air Date" = 'November 19, 2007';