with tmp as(
select
    pow(POINT - (select AVG(point) from test_results where TEST_ID =100),2) as zansa
from
    TEST_RESULTS
where
    TEST_ID =100
),avg_num as(

select
    avg(point)
from
    TEST_RESULTS
where
    TEST_ID =100 
),stv as(
select
    SQRT(AVG(zansa)) as stv
from
    tmp
)

select
    USER_ID as USER
    ,POINT AS PT
    ,CASE
        WHEN ROUND(((POINT - (select * from avg_num))*10)/(select * from stv)+50,1) = 0 THEN 50
    ELSE ROUND(((POINT - (select * from avg_num))*10)/(select * from stv)+50,1)
    END as DEV_VAL
from
    TEST_RESULTS
where
    TEST_ID =100
order by
    DEV_VAL desc
    ,USER_ID asc