Table: castro_jason_top24
Columns: week
theme
song_choice
original_artist
order
result

Question: What is the Original artist when the week number is top 9?
SQL: SELECT "original_artist" FROM castro_jason_top24 WHERE "week" = 'top 9'

Question: What is the Song choice when The Beatles were the original artist, with an order # of 4?
SQL: SELECT "song_choice" FROM castro_jason_top24 WHERE "original_artist" = 'the beatles' AND "order" = '4'

Question: What is the Song choice when Elaine Paige was the Original artist?
SQL: SELECT "song_choice" FROM castro_jason_top24 WHERE "original_artist" = 'elaine paige'

Question: What is the name of the Original artist when the week # is top 16 (8 men)?
SQL: SELECT "original_artist" FROM castro_jason_top24 WHERE "week" = 'top 16 (8 men)'

Question: What is the Result when the order is # 4, and the week # is top 12?
SQL: SELECT "result" FROM castro_jason_top24 WHERE "order" = '4' AND "week" = 'top 12'