SELECT
  USER_ID AS USER,
  "POINT" AS PT,
  CASE WHEN hensa = 0 THEN 50 ELSE
    50 + ROUND(((("POINT" - h) * 10) / hensa), 1) END AS DEV_VAL
FROM
  TEST_RESULTS
  LEFT JOIN (
    SELECT
      h,
      SQRT(AVG(bunsan1)) AS hensa
    FROM (
      SELECT
        USER_ID,
        h,
        ("POINT" - h) * ("POINT" - h) AS bunsan1
      FROM
        TEST_RESULTS
        LEFT JOIN (
          SELECT
            AVG("POINT") AS h
          FROM
            TEST_RESULTS
          WHERE
            TEST_ID = 100
        ) AS heikin ON 1 == 1
      WHERE
        TEST_ID = 100
      GROUP BY
        USER_ID
    ) AS bunsan
  ) AS hyozyunhensa
WHERE
  TEST_ID = 100
ORDER BY
  DEV_VAL DESC,
  USER_ID