user: ### NOW ANSWER:
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?
Columns: ['Number', 'Name of the song', 'Singer', 'Drama', 'Kind of the song']
Types: ['real', 'text', 'text', 'text', 'text']
Sample row: [1.0, '心計', 'Hacken Lee', 'Revolving Doors of Vengeance', 'Opening theme']
SQL:

assistant: SELECT "Name of the song" FROM "Table" WHERE "Kind of the song" = 'Opening theme' AND "Drama" = 'Revolving Doors of Vengeance';