-- 查询订单数大于5的用户 SELECT user_id, COUNT(*) AS order_count FROM orders GROUP BY user_id HAVING COUNT(*) > 5; -- 查询平均订单金额大于1000的用户 SELECT user_id, AVG(amount) AS avg_amount FROM orders GROUP BY user_id HA