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