user: Question: If the night rank is 9, what is the total share number?
Columns: ['#', 'Episode', 'Rating', 'Share', 'Rating/Share (18-49)', 'Viewers (millions)', 'Rank (Night)']
Types: ['real', 'text', 'text', 'real', 'text', 'text', 'text']
Sample row: [1.0, '"Out Here in the Fields"', '8.2', 14.0, '3.8/10', '11.33', '3']
SQL:

assistant: SELECT SUM("Share") FROM "Table" WHERE "Rank (Night)" = '9';