If the night rank is 9, what is the total share number?
CREATE TABLE table_23342 (
    "#" real,
    "Episode" text,
    "Rating" text,
    "Share" real,
    "Rating/Share (18-49)" text,
    "Viewers (millions)" text,
    "Rank (Night)" text
)
SELECT COUNT("Share") FROM table_23342 WHERE "Rank (Night)" = '9'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: If the night rank is 9, what is the total share number? ### Input: CREATE TABLE table_23342 (
    "#" real,
    "Episode" text,
    "Rating" text,
    "Share" real,
    "Rating/Share (18-49)" text,
    "Viewers (millions)" text,
    "Rank (Night)" text
) ### Response: SELECT COUNT("Share") FROM table_23342 WHERE "Rank (Night)" = '9'