select
    USER_ID as 'USER',
    POINT as 'PT',
    round((POINT -  avg(POINT) OVER()) * 10 /
    (select sqrt(avg(a)) from (
        select 
            POW((POINT -  avg(POINT) OVER()),2) as a
        from TEST_RESULTS
        where TEST_ID = 100
)) + 50,1) as 'DEV_VAL'
from TEST_RESULTS
where TEST_ID = 100
order by 3 desc, 1