AI Reporting

SELECT
    c.customer_name,
    c.customer_id,
    SUM(so.total_value) AS total_revenue,
    COUNT(so.order_id) AS order_count,
    AVG(so.total_value) AS avg_order_value
FROM sales_orders so
INNER JOIN customers c ON so.customer_id = c.customer_id
WHERE so.order_date BETWEEN '2025-10-01' AND '2025-12-31'
GROUP BY c.customer_id, c.customer_name
ORDER BY total_revenue DESC;