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