WITH TEST_RESULTS_100 AS (
  SELECT
    *
  FROM
    TEST_RESULTS
  WHERE
    TEST_ID = "100"
),
CNT AS (
  SELECT
    COUNT(1) AS CNT
  FROM
    TEST_RESULTS_100
),
HEIKIN AS (
  SELECT
    AVG(POINT) AS AVGPT
  FROM
    TEST_RESULTS_100
),
HENSA AS (
  SELECT
    SQRT(SUM((POINT - AVGPT) * (POINT - AVGPT)) / CNT) AS HENSA
  FROM
    TEST_RESULTS_100
    CROSS JOIN CNT
    CROSS JOIN HEIKIN
)
SELECT
  USER_ID AS `USER`,
  POINT AS `PT`,
  CASE WHEN HENSA = 0 THEN 50 ELSE round((POINT - AVGPT) * 10 / HENSA + 50, 1) END AS `DEV_VAL`
FROM
  TEST_RESULTS_100
  CROSS JOIN HEIKIN
  CROSS JOIN HENSA
ORDER BY
  DEV_VAL DESC,
  USER