分析

关键词：group by,min

用法：

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

代码

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