with A as (
    select avg(POINT) as AVG from TEST_RESULTS where TEST_ID = '100'
) 
, B as (
    select 
        SQRT ( 
            AVG (
                  ( point - A.AVG )  * ( point - A.AVG ) 
            )
        ) as hensa
        from TEST_RESULTS inner join A  
        where TEST_ID = '100'
)
select 
    USER_ID as USER
    ,POINT as PT
    , case when hensa = 0 then 50
        else round ( ( abs(point - A.AVG) * 10 / hensa ) , 1 ) + 50
        end
      as DEV_VAL
from TEST_RESULTS
inner join A
inner join B
order by DEV_VAL desc , USER asc