Untitled

SELECT 
    count(serialnumber) serials,
    Product,
    Size,
    Bin,
    Location,
    Previousbin AS PrevBin,
    PreviousLocation AS PrevLoc,
    date(Lastscandate) date,
    Username AS User
FROM
    shard.inventoryitemupdate 
WHERE
    username = 'Elsa Y. Chavez Flores'
        AND lastscandate >= '2023-03-28 06:00:00'
        AND lastscandate <= '2023-03-28 18:30:00'
        AND qtyonhand = 1
GROUP BY User, date
ORDER BY lastscandate ASC