with 
avg as(
    select avg(point) as avg_pt from TEST_RESULTS where TEST_ID = '100'
),
devi2 as (
    select 
        USER_ID as USER,
        POINT as PT,
        pow(point - (select avg_pt from avg), 2) as devi2
    from TEST_RESULTS
    where TEST_ID = '100'
),
var_std as (
    select 
        avg(devi2) as var,
        SQRT(avg(devi2)) as std
    from devi2
)
select
    USER,
    PT,
    case when (select std from var_std) = 0 then 50
        else round(10 * (pt - (select avg_pt from avg)) / (select std from var_std) + 50 , 1)
    end as DEV_VAL
from devi2
order by DEV_VAL desc, USER asc
;