select c_pro as '省份', sum(case c_isfee when '是' then 1 else 0 end) as '交费人数', sum(case c_isfee when '否' then 1 else 0 end) as '未交费人数' from c_userinfo group by c_pro order by c_pro asc