Table: men_songs
Columns: number
name_of_the_song
singer
drama
kind_of_the_song

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?
SQL: SELECT "name_of_the_song" FROM men_songs WHERE "kind_of_the_song" = 'opening theme' AND "drama" = 'revolving doors of vengeance'