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" ;