SELECT distinct maker,instrument FROM horns where maker="Sonore" order by Maker,Instrument
Listing for Sonore
Instrument:
Alto Horn
Bugle
Fluglehorn
Sousaphone
Trumpet
Tuba
Return