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