with tmp1 as(
select POINT,USER_ID,
avg(POINT) over() as val1,
POINT - avg(POINT) over() as val2
  from TEST_RESULTS
 where TEST_ID = '100'),
tmp2 as(
select POINT,USER_ID,
     avg(val2*val2) over() as val3,
sqrt(avg(val2*val2) over()) as val4,
10 * (POINT-val1) as val5
from tmp1),
tmp3 as(
select POINT,USER_ID,
case when val4 = 0 then 50
     else val5/val4 + 50 end as val7
from tmp2)
select USER_ID as USER,
POINT as PT,
round(val7,1) as DEV_VAL
  from tmp3
order by DEV_VAL desc,USER_ID