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 times was each instrument used?
assistant
SELECT instrument , COUNT( * ) FROM instruments GROUP BY instrument;
human
Which instrument was the most used?
assistant
SELECT instrument FROM instruments GROUP BY instrument ORDER BY COUNT( * ) DESC LIMIT 1 ;