SELECT
COUNT( CASE WHEN month(login.cLoginTime)="1" THEN `user`.strGuid END) 一月
,COUNT( CASE WHEN month(login.cLoginTime)="2" THEN `user`.strGuid END) 二月
,COUNT( CASE WHEN month(login.cLoginTime)="3" THEN `user`.strGuid END) 三月
FROM aocslogininfo login, aocsuserinfo `user`,aocssiteinfo site
WHERE `user`.strGuid=login.strUserGuid AND site.strGuid=`user`.strGuidForSiteInfo
/*AND DATE(login.cLoginTime )NOT IN (SELECT DATE(holiday) FROM holiday )*/
GROUP BY site.strDistrict
,count( case when month(login.cLoginTime)="12" then `user`.strGuid end) 十二月
FROM aocslogininfo login, aocsuserinfo `user`,aocssiteinfo site
WHERE `user`.strGuid=login.strUserGuid AND site.strGuid=`user`.strGuidForSiteInfo
/*AND DATE(login.cLoginTime )NOT IN (SELECT DATE(holiday) FROM holiday )*/
GROUP BY site.strDistrict