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