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 like 'Maciel victoria Ortega 9383%'
        AND lastscandate >= '2024-08-01 00:00:00'
        AND lastscandate <= '2024-08-01 23:30:00'
        AND qtyonhand = 1
#GROUP BY Serial
ORDER BY lastscandate ASC