with tmp1 as(
select POINT,USER_ID,
avg(POINT) over() as val1,
abs(POINT - avg(POINT) over()) as val2
  from TEST_RESULTS),
tmp2 as(
select POINT,USER_ID,
val1,val2,
     avg(val2*val2) over() as val3,
sqrt(avg(val2*val2) over()) as val4,
10 * abs(POINT-val1) as val5
from tmp1),
tmp3 as(
select POINT,USER_ID,
-- val5/val4 as val6
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,2) as DEV_VAL
  from tmp3
order by val7 desc,USER_ID