sql查询找到太频繁订购的客户？

SELECT customer_id, COUNT(order_id) / DATEDIFF(MAX(order_date), MIN(order_date)) AS avg_orders_per_day
FROM order
GROUP BY customer_id

SELECT customer_id, customer_name
FROM customer
WHERE customer_id IN (
    SELECT customer_id
    FROM (
        SELECT customer_id, COUNT(order_id) / DATEDIFF(MAX(order_date), MIN(order_date)) AS avg_orders_per_day
        FROM order
        GROUP BY customer_id
    ) AS avg_orders
    WHERE avg_orders_per_day > 3
)