CREATE TABLE table_name_98 (week INT, date VARCHAR)

What week has a date of September 3, 2000?
SELECT AVG(week) FROM table_name_98 WHERE date = "september 3, 2000"
SELECT AVG("week") FROM "table_name_98" WHERE "date" = "september 3, 2000"