SQL Generation

Between May and September 2025, how many Volvo vehicles were sold during the first week of each month, grouped by dealership?

WITH filtered_sales AS ( SELECT s.*, v.make, d.name AS dealership_name FROM sales s JOIN vehicles v ON s.vehicle_id = v.vehicle_id JOIN dealerships d ON s.branch_id = d.branch_id WHERE v.make = 'Volvo' AND s.sale_date >= DATE '2025-05-01' AND s.sale_date < DATE '2025-10-01' AND EXTRACT(DAY FROM s.sale_date) <= 7 ) SELECT dealership_name, DATE_TRUNC('month', sale_date) AS month, COUNT(*) AS volvo_sales FROM filtered_sales GROUP BY dealership_name, DATE_TRUNC('month', sale_date) ORDER BY month, dealership_name;

SELECT
    d.name AS dealership_name,
    TO_CHAR(s.sale_date, 'YYYY-MM') AS sale_month,
    COUNT(s.sale_id) AS number_of_volvos_sold
FROM
    sales AS s
JOIN
    vehicles AS v ON s.vehicle_id = v.vehicle_id
JOIN
    dealerships AS d ON s.branch_id = d.branch_id
WHERE
    v.make = 'Volvo'
    AND s.sale_date >= '2025-05-01' AND s.sale_date < '2025-10-01'
    AND EXTRACT(DAY FROM s.sale_date) <= 7
GROUP BY
    d.name,
    sale_month
ORDER BY
    dealership_name,
    sale_month;