SELECT 
    vend_id,
    MIN(prod_price) AS cheapest_item
FROM
    Products
GROUP BY
    vend_id
ORDER BY
    cheapest_item
;

分析

题目关键词：每个供应商成本最低的产品、从最低成本到最高成本对结果进行升序排序 sql关键词：group by,min

用法：

group by ---分组 min---求最小值