Untitled

SELECT 
    qtyonhand, 
    CONCAT('s', serialnumber) AS Serial,
    Product,
    Size,
    Bin,
    Location,
    Previousbin AS PrevBin,
    PreviousLocation AS PrevLoc,
    Lastscandate,
    Username AS User,
    notes
FROM
    shard.inventoryitemupdate
WHERE
    username = 'Jesus castillo'
        AND lastscandate >= '2022-11-30 12:00:00'
        AND lastscandate <= '2022-11-30 13:30:00'
        AND location = '7-UC28L-5c'
        AND qtyonhand = 1
        #GROUP BY Bin
ORDER BY lastscandate ASC