SELECT distinct maker,instrument FROM horns where maker="Brigadier" order by Maker,Instrument
Listing for Brigadier
Instrument:
Trombone
Trumpet
Return