-- 查询订单金额大于平均值的订单 SELECT order_id, user_id, amount, created_at FROM orders WHERE amount > (SELECT AVG(amount) FROM orders); -- 查询购买过特定产品的用户 SELECT * FROM users WHERE id IN ( SELECT DISTINCT user_