CREATE TABLE table_203_664 (id DECIMAL, "club" TEXT, "town" TEXT, "founded" DECIMAL, "nickname" TEXT, "colours" TEXT, "home ground" TEXT, "titles" DECIMAL, "website" TEXT)

how many teams have the color red in their team colors ?
SELECT COUNT("club") FROM table_203_664 WHERE "colours" = 'red'
SELECT COUNT("club") FROM "table_203_664" WHERE "colours" = 'red'