Table: broadway_dance_data
Columns: song_title
artist
show
difficulty
effort
year
dancers

Question: What show featured the song "little shop of horrors"?
SQL: SELECT "show" FROM broadway_dance_data WHERE "song_title" = '"Little Shop of Horrors"'

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

Question: How many shows were in 1994?
SQL: SELECT COUNT("difficulty") FROM broadway_dance_data WHERE "year" = 1994