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
    CASE
        WHEN SQRT(AVG(zansa)) = 0 THEN 50
    ELSE
        SQRT(AVG(zansa))
    END as stv
from
    tmp
)
select
    USER_ID as USER
    ,POINT AS PT
    ,ROUND(((POINT - (select * from avg_num))*10)/(select * from stv)+50,1) as DEV_VAL
from
    TEST_RESULTS
where
    TEST_ID =100
order by
    DEV_VAL desc
    ,USER_ID asc