SELECT USER_ID AS USER,
       POINT AS PT,
       ROUND((((POINT - AVG) * 10) / ST4) + 50,2)  AS DEV_VAL
  FROM TEST_RESULTS INNER JOIN (SELECT ROUND(SUM(POW(POINT - (SELECT AVG(POINT) FROM TEST_RESULTS WHERE TEST_ID = '100'),2)) / COUNT(*),2) AS ST4,
                                       (SELECT AVG(POINT) FROM TEST_RESULTS WHERE TEST_ID = '100') AS AVG
                                  FROM TEST_RESULTS
                                 WHERE TEST_ID = '100'
                                )
 WHERE TEST_ID = '100'
ORDER BY DEV_VAL DESC,
         USER ASC