题解 | #每个供应商成本最低的产品#

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

min/max 最大最小函数

group by 去重

GROUP BY 语句用于结合聚合函数，根据一个或多个列对结果集进行分组。

order by 排序 默认升序排列 desc降序排列