Table: auditions
Columns: week
theme
song_choice
original_artist
order
result

Question: Who was the original artist of the First solo theme?
SQL: SELECT "original_artist" FROM auditions WHERE "theme" = 'First Solo'

Question: What is the number of song choices where the original artist was Bright Eyes?
SQL: SELECT COUNT("song_choice") FROM auditions WHERE "original_artist" = 'Bright Eyes'

Question: Who was the original artist of the group performance theme?
SQL: SELECT "original_artist" FROM auditions WHERE "theme" = 'Group Performance'

Question: What is the order number of the Billboard Hot 100 Hits theme and the original artist was Sixpence None the Richer?
SQL: SELECT "order" FROM auditions WHERE "theme" = 'Billboard Hot 100 Hits' AND "original_artist" = 'Sixpence None the Richer'

Question: What was the number of weeks that had a Billboard Hot 100 Hits theme, an order number of 3, and an original artist of Sixpence None the Richer?
SQL: SELECT COUNT("week") FROM auditions WHERE "theme" = 'Billboard Hot 100 Hits' AND "order" = '3' AND "original_artist" = 'Sixpence None the Richer'