with A as(
select avg(POINT) AVGPOINT FROM TEST_RESULTS
), B AS(
select  sqrt(avg(pow((POINT-A.AVGPOINT),2))) HENSA
from A,TEST_RESULTS)
, C AS(
select USER_ID AS USER,POINT AS PT,ROUND(((POINT-A.AVGPOINT)*10/B.HENSA)+50,1) AS DEV_VAL
from A,TEST_RESULTS,B)
select * from C
order by DEV_VAL desc ,USER