-- SQL teaching example: use an isolated practice database and import the synthetic CSV.
-- Each row is a monthly region/model total, not an individual order or customer.
CREATE TABLE IF NOT EXISTS demo_sales (
    month TEXT, region TEXT, model TEXT,
    units INTEGER, unit_price INTEGER
);

SELECT region,
       SUM(units) AS total_units,
       SUM(units * unit_price) AS revenue,
       ROUND(1.0 * SUM(units * unit_price) / NULLIF(SUM(units), 0), 2) AS average_vehicle_value
FROM demo_sales
GROUP BY region
ORDER BY region;