SELECT
    USER_ID AS USER,
    POINT AS PT,
    -- avg,
    -- std,
    CASE
       WHEN std = 0 THEN 50
       ELSE ROUND((((POINT - avg) * 10) / std) + 50, 1)
    END AS DEV_VAL
    -- IF(ROUND((POINT - avg) * 10 / std + 50, 1) = 0, 50, ROUND((POINT - avg) * 10 / std + 50, 1)) AS DEV_VAL
FROM 
    TEST_RESULTS
CROSS JOIN (
    SELECT
        AVG(POINT) AS avg,
        -- COUNT(1) AS c,
        -- SUM(POW(POINT - (SELECT AVG(POINT) FROM TEST_RESULTS), 2))   AS c1,
        POW(SUM(POW(POINT - (SELECT AVG(POINT) FROM TEST_RESULTS WHERE TEST_ID = 100), 2)) / (SELECT COUNT(1) FROM TEST_RESULTS WHERE TEST_ID = 100), 0.5)   AS std
        -- POW(SUM(POW((POINT - (SELECT AVG(POINT) FROM TEST_RESULTS)), 2)) / (SELECT COUNT(1) FROM TEST_RESULTS), 0.5) AS std
    FROM
        TEST_RESULTS
    WHERE
        TEST_ID = 100
) AS logs
WHERE
    TEST_RESULTS.TEST_ID = 100
ORDER BY
    DEV_VAL DESC,
    USER_ID ASC