Table: brooke_white_audition
Columns: week
theme
song_choice
original_artist
order
result

Question: What is the Result when the Theme was by Dolly Parton?
SQL: SELECT "result" FROM brooke_white_audition WHERE "theme" = 'dolly parton'

Question: What is the Order # when the song choice was " you're so vain "?
SQL: SELECT "order" FROM brooke_white_audition WHERE "song_choice" = '" you''re so vain "'

Question: What is the Theme when the Original artist was carole king, and a Week # shows hollywood?
SQL: SELECT "theme" FROM brooke_white_audition WHERE "original_artist" = 'carole king' AND "week" = 'hollywood'

Question: What is the Result when the Song choice was "beautiful"?
SQL: SELECT "result" FROM brooke_white_audition WHERE "song_choice" = '"beautiful"'

Question: What Week # that is there an Order # of 7, and the Song choice was " let it be "?
SQL: SELECT "week" FROM brooke_white_audition WHERE "order" = '7' AND "song_choice" = '" let it be "'

Question: What is the Song choice when there is an Order # of 4?
SQL: SELECT "song_choice" FROM brooke_white_audition WHERE "order" = '4'