sql数据库语句，求大神指点

[当当当当当家]

大家看我两张图，里面的from********where就不需要管他了，现在我想得出图3来，各位有没有什么办法呢？

[xxfvba]

别 group by area

[当当当当当家]

补上图三

[xxfvba]

select year(t3.[HXMonth]) [year], count(case when t3.area='YA' then t3.sType end) 云安, ...... group by year(t3.[HXMonth]) order by [year]

[当当当当当家]

引用 2 楼 xxfvba 的回复:

select year(t3.[HXMonth]) [year], count(case when t3.area='YA' then t3.sType end) 云安, ...... group by year(t3.[HXMonth]) order by [year]

这样是不行的

[qq_36641748]

select 
year(t3.hxmonth) year,
sum(case when t3.area='ya' then 1 else 0 end ) as 云安 ,
sum(case when t3.area='ld' then 1 else 0 end ) as 罗定 ,
sum(case when t3.area='xx' then 1 else 0 end ) as 新兴
from ****** where 1=1 
group by  year(t3.hxmonth) 
order by year