CREATE TABLE table_name_8 (week NUMBER, date VARCHAR2)

What average week has october 8, 1950 as the date?
SELECT AVG(week) FROM table_name_8 WHERE date = "october 8, 1950"
SELECT AVG("week") FROM "table_name_8" WHERE "date" = "october 8, 1950"