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
What are the vocal types used in song 'Badlands'?
assistant
SELECT TYPE FROM vocals AS T1 JOIN songs AS T2 ON T1.songid = T2.songid WHERE title = 'Badlands'
human
Find all the instruments ever used by the musician with last name 'Heilo'?
assistant
SELECT instrument FROM instruments AS T1 JOIN Band AS T2 ON T1.bandmateid = T2.id WHERE T2.lastname = 'Heilo'
human
Which song has the most vocals?
assistant
SELECT title FROM vocals AS T1 JOIN songs AS T2 ON T1.songid = T2.songid GROUP BY T1.songid ORDER BY count(*) DESC LIMIT 1
human
What are all the instruments used?
assistant
SELECT DISTINCT instrument FROM Instruments
human
What is the most used instrument?
assistant
SELECT instrument FROM instruments GROUP BY instrument ORDER BY count(*) DESC LIMIT 1
human
What is the type of vocables that appears most frequently?
assistant
SELECT TYPE FROM vocals GROUP BY TYPE ORDER BY COUNT( * ) DESC LIMIT 1 ;