human
Schema:
Songs (SongId, Title)
Albums (AId, Title, Year, Label, Type)
Band (Id, Firstname, Lastname)
Instruments (SongId, BandmateId, Instrument)
Performance (SongId, Bandmate, StagePosition)
Tracklists (AlbumId, Position, SongId)
Vocals (SongId, Bandmate, Type)
Please answer with SQL.
assistant
Sure, I understand.
human
Show me all songs containing the word 'Badlands'.
assistant
SELECT * FROM Songs WHERE Title LIKE '%Badlands%';
human
How about a song exactly named 'Badlands'?
assistant
SELECT * FROM Songs WHERE Title = 'Badlands';
human
Who performed it in the back stage position? Show me the first and last names.
assistant
SELECT T2.firstname , T2.lastname FROM Performance AS T1 JOIN Band AS T2 ON T1.bandmate = T2.id JOIN Songs AS T3 ON T3.SongId = T1.SongId WHERE T3.Title = "Badlands" AND T1.StagePosition = "back" ;