CREATE TABLE table_28140141_1 (artist VARCHAR, show VARCHAR)

How many artists were there for the show thoroughly modern millie?
SELECT COUNT(artist) FROM table_28140141_1 WHERE show = "Thoroughly Modern Millie"
SELECT COUNT("artist") FROM "table_28140141_1" WHERE "Thoroughly Modern Millie" = "show"