Untitled

SELECT 
    CONCAT('s', serialnumber) serial, 
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    inventoryitem
WHERE
    product LIKE 'ZMER-W%' AND qtyonhand = 1
        AND location LIKE '7-%%'
        AND lastscandate >= '2023-01-01 00:00:00'
        AND lastscandate <= '2024-05-30 23:59:59'
        group by location asc