一条SQL 写不出就多条SQL嘛。以胸围为例:
SELECT 性别,SUM(偏大) [偏大],SUM(偏小) [偏小],SUM(正常) [正常],SUM(偏大+偏小+正常) [合计] FROM (
SELECT 性别,(CASE WHEN 胸围偏差='偏大' THEN 1 ELSE 0 END) [偏大],(CASE WHEN 胸围偏差='偏小' THEN 1 ELSE 0 END) [偏小],(CASE WHEN 胸围偏差='正常' THEN 1 ELSE 0 END) [正常] FROM TABLE WHERE .............
) T GROUP BY 性别