WITH CTE 
AS (SELECT 1 ID, round(4*RAND(
                        checkSUM(NEWID())
                        )
                        ,0) W
    UNION ALL
    SELECT ID+1,round(4*RAND(
                        checkSUM(NEWID())
                        )
                        ,0) W from CTE 
    where ID<10) ---кол-во человек

select ID,100+W,row_number()over(order by W,ID) C,NTILE(3) OVER(ORDER BY W) AS NT
from CTE 
order by W