Beginner SQL Learning

Select 
 Row_number() 
 over(Order By num desc) 
 as Row_number
,userid
,num
 From
(
Select
userid,count(userid) as num
From T_alocate 
Group By userid Having num <>1
)X

Select 
 Row_number() 
 over(partition By num Order By num ) 
 as Row_number
,userid
,num
 From
(
Select
userid,count(userid) as num
From T_alocate 
Group By userid 
Having num <>1
Order By num desc
)X