CREATE TABLE table_name_79 (week INT, date VARCHAR)

How many weeks have September 14, 2008 as the date?
SELECT SUM(week) FROM table_name_79 WHERE date = "september 14, 2008"
SELECT SUM("week") FROM "table_name_79" WHERE "date" = "september 14, 2008"