SELECT USER_ID AS USER
      ,POINT AS PT
      ,ROUND((POINT - (SELECT AVG(POINT) AS a
                         FROM TEST_RESULTS
                        WHERE TEST_ID = '100')) * 10
       / (SELECT SQRT(AVG(POW((TEST_RESULTS.POINT - sub.a), 2))) AS var
            FROM TEST_RESULTS 
                ,(SELECT AVG(POINT) AS a
                    FROM TEST_RESULTS
                   WHERE TEST_ID = '100') AS sub
           WHERE TEST_ID = '100'
       ) + 50, 1) AS DEV_VAL
  FROM TEST_RESULTS
 WHERE TEST_ID = '100'
 ORDER BY DEV_VAL DESC
         ,USER_ID