CREATE TABLE table_name_23 (week VARCHAR, date VARCHAR)

How many weeks in total has bye as the date?
SELECT COUNT(week) FROM table_name_23 WHERE date = "bye"
SELECT COUNT("week") FROM "table_name_23" WHERE "bye" = "date"