Untitled

SELECT 
    COUNT(productcode) SamplesShipped,
    DATE(orderdate) date,
    status,
    CASE
        WHEN
            DATE(orderdate) >= '2022-08-14'
                AND DATE(orderdate) <= '2022-08-20'
        THEN
            'WeekOf8.14'
        WHEN
            DATE(orderdate) >= '2022-08-21'
                AND DATE(orderdate) <= '2022-08-27'
        THEN
            'WeekOf8.21'
        WHEN
            DATE(orderdate) >= '2022-08-28'
                AND DATE(orderdate) <= '2022-09-02'
        THEN
            'WeekOf8.28'
        WHEN DATE(orderdate) >= '2022-09-03' THEN 'WeekOf9.3'
    END AS 'Week'
FROM
    shipment
WHERE
    productcode LIKE 'BTYS%'
        AND orderdate >= '2022-08-14'
        AND status = 'Shipped'
GROUP BY Week