Untitled

SELECT 
    qtyonhand,
    CONCAT('s', serialnumber) AS Serial,
    Product,
    Size,
    Bin,
    Location,
    Previousbin AS PrevBin,
    PreviousLocation AS PrevLoc,
    Lastscandate,
    Username AS User
FROM
    shard.inventoryitemupdate
WHERE
    username like 'Josefina Quezada 6014%'
        AND lastscandate >= '2024-07-19 00:00:00'
        AND lastscandate <= '2024-07-19 23:30:00'
        AND qtyonhand = 1
        #group by location
ORDER BY lastscandate ASC