WITH avg AS ( 
    SELECT avg(POINT) as a_point
    from TEST_RESULTS
    where TEST_ID='100'
),
sa as(
select user_id,point,(point - a_point) as s_point,(point - a_point)*10 as ten
from TEST_RESULTS,avg
where TEST_ID='100'
),
bu as (
select 
case when sqrt(sum(s_point*s_point)/count(*)) = 0 then 50
else sqrt(sum(s_point*s_point)/count(*))
end  as hyou,count(*) from sa
),
six as (
 select sa.ten/bu.hyou as val,user_id,point from
 sa,bu
)
select user_id as USER ,point as PT ,round(val+50,1) as DEV_VAL from six
order by 3 desc,1