select vend_id,min(prod_price) as cheapest_item 
from Products  group by vend_id having  cheapest_item 
order by cheapest_item;