select vend_id,MIN(prod_price) as cheapest_item
from
    Products
group by
    vend_id
order by
    cheapest_item