# group by vend_id 和 窗口子句over(partition by vend_id) 
# 它们的作用、效果是不完全一样的
select
    vend_id,
    min(prod_price) as cheapest_item
from Products
group by vend_id
order by cheapest_item asc
;