SCHEMA:
CREATE TABLE table_name_9 (week INTEGER, date VARCHAR)
User Question:
What's the mean week number for November 12, 1978?


SELECT AVG(week) FROM table_name_9 WHERE date = "november 12, 1978"