SELECT
  USER_ID AS USER,
  "POINT" AS PT,
  ROUND(50 + (("POINT" - h) * 10 / hensa), 1) 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