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