CREATE TABLE table_23342 ("#" FLOAT, "Episode" CLOB, "Rating" CLOB, "Share" FLOAT, "Rating/Share  ( 18-49 ) " CLOB, "Viewers  ( millions ) " CLOB, "Rank  ( Night ) " CLOB)

If the night rank is 9, what is the total share number?
SELECT COUNT("Share") FROM table_23342 WHERE "Rank (Night)" = '9'
SELECT COUNT("Share") FROM "table_23342" WHERE "Rank (Night)" = '9'