with avv as(
SELECT

 avg(point) as average 
 from 
TEST_RESULTS where TEST_ID='100'
),
a as 
(select
 point - average as sa
 from TEST_RESULTS,avv where  TEST_ID='100'
),
bb as
(select sa*sa as sa from a),
 b as 
(
select 
 avg(sa) bunsan
from bb
) ,
c as (
select sqrt(bunsan) hensa from b
)

select
 USER_ID as USER,
  POINT as PT,
  round(10*(point - avv.average) / c.hensa + 50 , 1)as DEV_VAL
from 
TEST_RESULTS, avv, c
where TEST_ID='100'
order  by 3 desc,1 asc