from OrderItems
group by order_num
having total_price>=1000
order by order_num;

解题思路：1⃣️聚合函数+having筛选条件。2⃣️group by order_num，按照order_num分组。