/*SELECT
  USER_ID AS 'USER',
  POINT AS 'PT',
  POINT - AVERAGE AS 'DEV_VAL'
FROM
  (*/
    SELECT
      USER_ID,
      POINT,
      AVG(POINT) AS 'AVERAGE'
    FROM
      TEST_RESULTS
    WHERE
      TEST_ID = '100'
--  )