Table: kristy_cook_top24
Columns: week
theme
song_choice
original_artist
order
result

Question: WHERE THE THEME WAS "YEAR THEY WERE BORN," WHAT THE TOTAL NUMBER OF RESULTS?
SQL: SELECT COUNT("result") FROM kristy_cook_top24 WHERE "theme" = 'Year They Were Born'

Question: WHAT IS THE RESULT FOR THE SONG WHERE THE ORIGINAL ARTIST IS BETTY EVERETT?
SQL: SELECT "result" FROM kristy_cook_top24 WHERE "original_artist" = 'Betty Everett'

Question: WHAT WAS HER SONG CHOICE WHEN THE WEEK WAS TOP 10?
SQL: SELECT "song_choice" FROM kristy_cook_top24 WHERE "week" = 'Top 10'

Question: WHERE THE WEEK NUMBER WAS TOP 8, WHAT WAS THE THEME?
SQL: SELECT "theme" FROM kristy_cook_top24 WHERE "week" = 'Top 8'