/* Q12. Find the vendor Name having the vendor_nos 305 , 380 , 391

Select Vendor_name,Vendor_nos

from ITEM_TABLE

where Vendor_nos IN (305,380,391)

/* OUTPUT

Vendor_name Vendor_nos

Mhw Ltd 305

Anchor Distilling(preiss Imports) 391

Mhw Ltd 305

Phillips Beverage Company 380

*/