select left(tag,2), Sum(case when vendor='A' And Model='1' Then 1 Else 0 End) As A厂型号1总数, Sum(case when vendor='A' And Model='2' Then 1 Else 0 End) As A厂型号2总数, Sum(case when vendor='B' And Model='1' Then 1 Else 0 End) As A厂型号1总数, Sum(case when vendor='B' And Model='2' Then 1 Else 0 End) As A厂型号2总数, Count(*) as 小区总数 from csmain group by left(tag,2)
Sum(case when vendor='A' And Model='1' Then 1 Else 0 End) As A厂型号1总数,
Sum(case when vendor='A' And Model='2' Then 1 Else 0 End) As A厂型号2总数,
Sum(case when vendor='B' And Model='1' Then 1 Else 0 End) As A厂型号1总数,
Sum(case when vendor='B' And Model='2' Then 1 Else 0 End) As A厂型号2总数,
Count(*) as 小区总数
from csmain
group by left(tag,2)