行转列，多行汇总case when的使用

根据性别查询每种材料的总数量

select 

	case when sex=1 then '男'
		 when sex=0 then '女'
	else '' end '性别',

	sum(case when F_QDLX='DYZC' and sex=1 then F_SL 
	when F_QDLX='DYZC' and sex=0 then F_SL 
	end) '单元主材',

	sum(case when F_QDLX='DYFC' and sex=1 then F_SL 
	when F_QDLX='DYFC' and sex=0 then F_SL 
	end) '单元辅材'

from AA
group by
case when sex=1 then '男'
	 when sex=0 then '女'
else '' end