SELECT customer_id AS 客户, createtime AS 创建时间, mtmusername AS 下单系统账号, NAME AS 姓名, gender AS 性别, neck AS 颈围, customer_neck AS 客户颈围, ( CASE WHEN - 1 > ( customer_neck-neck ) THEN '偏小' WHEN 1 < ( customer_neck-neck ) THEN '偏大' ELSE '正常' END ) AS 颈围偏差, chest AS 胸围, customer_chest AS 客户胸围, ( CASE WHEN - 2 > ( customer_chest- chest ) THEN '偏小' WHEN 2 < ( customer_chest- chest ) THEN '偏大' ELSE '正常' END ) AS 胸围偏差, mid_waist AS 中腰围, customer_mid_waist AS 客户中腰围, ( CASE WHEN - 2 > ( customer_mid_waist- mid_waist ) THEN '偏小' WHEN 2 < ( customer_mid_waist- mid_waist ) THEN '偏大' ELSE '正常' END ) AS 中腰围偏差, abdomen AS 裤腰围, customer_abdomen AS 客户腰围, ( CASE WHEN - 2 > ( customer_abdomen- abdomen ) THEN '偏小' WHEN 2 < ( customer_abdomen- abdomen ) THEN '偏大' ELSE '正常' END ) AS 裤腰围偏差 , buttock AS 臀围, customer_buttock AS 客户臀围, ( CASE WHEN - 2 > ( customer_buttock- buttock ) THEN '偏小' WHEN 2 < ( customer_buttock- buttock ) THEN '偏大' ELSE '正常' END ) AS 臀围偏差 , leg_end AS 腿根围, customer_leg_end AS 客户腿根围, ( CASE WHEN - 2 > ( customer_leg_end- leg_end ) THEN '偏小' WHEN 2 < ( customer_leg_end- leg_end ) THEN '偏大' ELSE '正常' END ) AS 腿根围偏差 , crotch AS 通裆, customer_crotch AS 客户通裆, ( CASE WHEN - 2 > ( customer_crotch-crotch ) THEN '偏小' WHEN 2 < ( customer_crotch-crotch ) THEN '偏大' ELSE '正常' END ) AS 通档偏差, upper_arm AS 上臂围, customer_upper_arm AS 客户上臂围, ( CASE WHEN - 1.5 > (customer_upper_arm- upper_arm ) THEN '偏小' WHEN 1.5 < ( customer_upper_arm- upper_arm ) THEN '偏大' ELSE '正常' END ) AS 上臂偏差, wrist AS 手腕围, customer_wrist AS 客户手腕围, ( CASE WHEN - 1 > (customer_wrist-wrist ) THEN '偏小' WHEN 1.5 < (customer_wrist- wrist ) THEN '偏大' ELSE '正常' END ) AS 手腕偏差, shoulder AS 肩宽, customer_shoulder AS 客户总肩宽, ( CASE WHEN - 1 > (customer_shoulder-shoulder ) THEN '偏小' WHEN 1 < ( customer_shoulder-shoulder ) THEN '偏大' ELSE '正常' END ) AS 肩宽偏差, front_shoulder AS 前肩宽, customer_front_shoulder AS 客户前肩宽, ( CASE WHEN - 1 > (customer_front_shoulder- front_shoulder ) THEN '偏小' WHEN 1 < ( customer_front_shoulder- front_shoulder ) THEN '偏大' ELSE '正常' END ) AS 前肩偏差, back_waistline AS 后腰节长, customer_back_waistline AS 客户后腰节长, ( CASE WHEN - 1 > ( customer_back_waistline-back_waistline ) THEN '偏小' WHEN 1 < ( customer_back_waistline-back_waistline ) THEN '偏大' ELSE '正常' END ) AS 后腰节偏差, front_waistline AS 前腰节长, customer_front_waistline AS 客户前腰节长, ( CASE WHEN - 1 > (customer_front_waistline-front_waistline ) THEN '偏小' WHEN 1 < ( customer_front_waistline-front_waistline ) THEN '偏大' ELSE '正常' END ) AS 前腰节偏差, back_clothe AS 后衣长, customer_back_clothe AS 客户后衣长, ( CASE WHEN - 2 > (customer_back_clothe - back_clothe ) THEN '偏小' WHEN 2 < ( customer_back_clothe- back_clothe ) THEN '偏大' ELSE '正常' END ) AS 后衣偏差, back_waist AS 后腰高, customer_back_waist AS 客户后腰高, ( CASE WHEN - 1 > ( customer_back_waist-back_waist ) THEN '偏小' WHEN 1 < ( customer_back_waist-back_waist ) THEN '偏大' ELSE '正常' END ) AS 后腰偏差, front_waist AS 前腰高, customer_front_waist AS 客户前腰高, ( CASE WHEN - 1 > (customer_front_waist- front_waist ) THEN '偏小' WHEN 1 < ( customer_front_waist- front_waist ) THEN '偏大' ELSE '正常' END ) AS 前腰偏差, leg AS 裤长, customer_leg AS 客户裤长, ( CASE WHEN - 2.5 > (customer_leg- leg ) THEN '偏小' WHEN 2.5 < ( customer_leg - leg ) THEN '偏大' ELSE '正常' END ) AS 裤长偏差, arm AS 袖长, customer_arm AS 客户袖长, ( CASE WHEN - 2 > (customer_arm - arm ) THEN '偏小' WHEN 2 < ( customer_arm - arm ) THEN '偏大' ELSE '正常' END ) AS 袖长偏差, measure_id AS measure表ID, weight AS 体重, height AS 身高, weightunit AS 体重单位, heightunit AS 身高单位 FROM customer_measure
