CREATE TABLE table_74235 ("Song title" CLOB, "Artist" CLOB, "Show" CLOB, "Difficulty" FLOAT, "Effort" FLOAT, "Year" FLOAT, "Dancers" CLOB)

How many artists were there for the show thoroughly modern millie?
SELECT COUNT("Artist") FROM table_74235 WHERE "Show" = 'Thoroughly Modern Millie'
SELECT COUNT("Artist") FROM "table_74235" WHERE "Show" = 'Thoroughly Modern Millie'