Untitled

SELECT 
    CONCAT('s', serialnumber) AS Serial,
    Product,
    Size,
    Bin,
    Location,
    Previousbin AS PrevBin,
    PreviousLocation AS PrevLoc,
    Lastscandate,
    Username AS User
FROM
    shard.inventoryitemupdate 
WHERE
    username = 'Susana Alvarez Orozco'
        AND lastscandate >= '2023-01-27 06:00:00'
        AND lastscandate <= '2023-01-27 16:30:00'
        AND qtyonhand = 1
#GROUP BY Serial
ORDER BY lastscandate ASC