22,300
社区成员




select sum(case when UserSalary >9999 and UserAge >35 then 1 else 0 end ) as count1,
sum(case when UserSalary >9999 and UserAge <35 then 1 else 0 end ) as count2,
sum(case when UserSalary <9999 and UserAge >35 then 1 else 0 end ) as count3,
sum(case when UserSalary <9999 and UserAge <35 then 1 else 0 end ) as count4
from UserInfo
select COUNT(用户编号) as count1 from UserInfo where UserSalary >9999 and UserAge >35
union all select COUNT(用户编号) as count2 from UserInfo where UserSalary >9999 and UserAge <35
union all select COUNT(用户编号) as count3 from UserInfo where UserSalary <9999 and UserAge >35
union all select COUNT(用户编号) as count4 from UserInfo where UserSalary <9999 and UserAge <35