SELECT T3.USER_ID USER
      ,T3.POINT PT
--      ,T4.POINTA
--      ,T4.HYO
      ,CASE
        WHEN T4.HYO=0 THEN 50
        ELSE ROUND((T3.POINT-T4.POINTA)*10/T4.HYO+50,1) 
       END DEV_VAL
  FROM TEST_RESULTS T3
  ,
  (
    SELECT POINTA,SQRT(AVG(wk)) HYO
      FROM
      (
        SELECT T1.USER_ID
              ,T1.POINT
              ,T2.POINTA
              ,(POINT-POINTA)*(POINT-POINTA) wk
          FROM TEST_RESULTS T1
          , 
            (  
                SELECT AVG(POINT) POINTA
                FROM TEST_RESULTS 
                WHERE TEST_ID = '100'
            ) T2
         WHERE TEST_ID = '100'
       ) 
    )T4
 WHERE TEST_ID = '100'
 ORDER BY DEV_VAL DESC,USER
;