SQL 分组查询（group by）

select order_num,count(order_num) as order_lines
from OrderItems 
group by order_num
order by order_lines

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

select order_num 
from OrderItems
group by order_num
having sum(quantity) >= 100# where不能用函数
order by order_num

select order_num,sum(item_price*quantity) as total_price
from OrderItems
group by order_num
having total_price >= 1000 
order by order_num

SELECT order_num, COUNT(*) AS items 
FROM OrderItems 
GROUP BY order_num 
HAVING COUNT(*) >= 3 
ORDER BY items, order_num;