注意 having的运算在sum函数、select函数、as函数后面

SELECT order_num,
SUM(item_price*quantity) total_price
FROM OrderItems
GROUP BY order_num
HAVING total_price>=1000
ORDER BY order_num