Who are the highest-value customers by lifetime spend?
🌍
Which regions generate the most revenue?
📉
Which products are underperforming vs targets?
💰
What is average order value per category?
Sample Query
SQL in Action
-- Top 5 Products by RevenueSELECT p.name, SUM(oi.quantity * oi.unit_price) AS revenue
FROM order_items oi
JOIN products p ON oi.product_id = p.product_id
GROUP BY p.name
ORDER BY revenue DESC LIMIT 5;
-- Monthly Revenue TrendSELECT DATE_FORMAT(order_date, '%Y-%m') AS month,
SUM(total_amount) AS monthly_revenue
FROM orders GROUP BY month
ORDER BY month;