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

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