mysql 结果作为条件

SELECT *
FROM customers
WHERE customer_id IN (
    SELECT customer_id
    FROM orders
    GROUP BY customer_id
    HAVING AVG(order_amount) > (
        SELECT AVG(order_amount)
        FROM orders
    )
);

SELECT c.*
FROM customers c
JOIN (
    SELECT customer_id, AVG(order_amount) as avg_amount
    FROM orders
    GROUP BY customer_id
) o ON c.customer_id = o.customer_id
WHERE o.avg_amount > (
    SELECT AVG(order_amount)
    FROM orders
);

SELECT c.*
FROM customers c
JOIN (
    SELECT customer_id, AVG(order_amount) as avg_amount
    FROM orders
    GROUP BY customer_id
) o ON c.customer_id = o.customer_id
WHERE o.avg_amount > (
    SELECT AVG(order_amount)
    FROM orders
);

SELECT c.*
FROM customers c
JOIN orders o ON c.customer_id = o.customer_id
GROUP BY c.customer_id
HAVING AVG(o.order_amount) > (
    SELECT AVG(order_amount)
    FROM orders
);