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