SELECT 
    USER_ID AS USER
    , POINT AS PT
    , ((POINT - AVG(POINT)) * 10 / SQRT((POWER(POINT - AVG(POINT), 2)))) + 50 AS DEV_VAL
FROM
    TEST_RESULTS
WHERE
    TEST_ID = '100'
ORDER BY 
    DEV_VAL DESC,
    USER ASC;