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
How many instruments does the song 'Le Pop' use?
assistant
SELECT count(DISTINCT instrument) FROM instruments AS T1 JOIN songs AS T2 ON T1.songid = T2.songid WHERE title = 'Le Pop'
human
How many instruments does the song 'Badlands' use?
assistant
SELECT count(DISTINCT instrument) FROM instruments AS T1 JOIN songs AS T2 ON T1.songid = T2.songid WHERE title = 'Badlands'
human
How many songs have used the instrument 'drums'?
assistant
SELECT count(*) FROM instruments WHERE instrument = 'drums'
human
How many unique labels are there for albums?
assistant
SELECT count(DISTINCT label) FROM albums
human
How many songs are there?
assistant
SELECT count(*) FROM Songs
human
How many bands are there?
assistant
SELECT COUNT( * ) FROM Band ;