question: What is the name of the song that is part of the opening theme and has a drama of the revolving doors of vengeance?
answer: SELECT name_of_the_song FROM table_name_82 WHERE kind_of_the_song = "opening theme" AND drama = "revolving doors of vengeance"
context: CREATE TABLE table_name_82 (name_of_the_song VARCHAR, kind_of_the_song VARCHAR, drama VARCHAR)