with TEST_RESULTS_1 as (select * from TEST_RESULTS where TEST_ID = 100)


select USER_ID,POINT,round(case when std == 0 then 50 else (POINT-avg)*10/std+50 end,1) as STD_VAL from TEST_RESULTS_1
left join
(select TEST_ID, sqrt(avg0-avg1) as std, avg from

(select TEST_ID	, avg(point2) as avg0
from (select TEST_ID, POWER(POINT,2) as point2 from TEST_RESULTS_1)
group by TEST_ID	
)
left join
(select TEST_ID, power(avg(POINT),2) as avg1, avg(POINT) as avg
from TEST_RESULTS_1
group by TEST_ID)
using (TEST_ID))
using(TEST_ID)
order by STD_VAL desc,USER_ID asc