SQL ejemplo 1

SELECT 
    EXTRACT(MONTH FROM order_date) AS month,
    AVG(total_amount) AS avg_order_value
FROM orders
WHERE EXTRACT(YEAR FROM order_date) = 2023
GROUP BY month
ORDER BY month;