Untitled

SELECT 
    CONCAT('s', serialnumber) serial,
    product,
    size,
    bin,
    location,
    lastscandate
FROM
    shard.inventoryitemupdate
WHERE
    location = 'Pulls'
    AND previouslocation <> 'Pulls'
    AND date(lastscandate) = '2023-10-04'
    and qtyonhand = 1