CREATE TABLE table_76704 ("Club" CLOB, "City" CLOB, "Sport" CLOB, "League" CLOB, "Venue" CLOB)

Which city has a club called the Huntsville Stars?
SELECT "City" FROM table_76704 WHERE "Club" = 'huntsville stars'
SELECT "City" FROM "table_76704" WHERE "Club" = 'huntsville stars'