Here is the Solution :

;with q as(

select ProductID, EventTime, RoleName

, ROW_NUMBER() over (order by EventTime) rn

, ROW_NUMBER() over (partition by...