sql 练手
#1. 标准化处理:先把min,max查出来作为一列,再套一层查询计算
SELECT
b.*,
(b.01_score - b.01_min)/(b.01_max - b.01_min) as 01_scale
FROM
( SELECT
a.*,
( SELECT max( 01_score ) FROM score_hb ) AS 01_max,
( SELECT min( 01_score ) FROM score_hb ) AS 01_min
FROM score_hb a
) b