CREATE TABLE table_name_55 (week INT, date VARCHAR)

What is the sum for the week with the date october 30, 1994?
SELECT SUM(week) FROM table_name_55 WHERE date = "october 30, 1994"
SELECT SUM("week") FROM "table_name_55" WHERE "date" = "october 30, 1994"