分析

关键词：having

用法：

  • where---过滤过滤指定的行
  • having--过滤分组，与group by连用

代码

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