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