select 日期,地域,活跃度,count(a.qq号) as \'qq号个数\' from
(select a.日期,a.qq号,a.地域,
if(b.msg>=200,\'高活跃度\',\'低活跃度\')  as \'活跃度\'
from table_user a left join table_act b
        on a.qq号=b.qq  and  a.日期=b.ftime
where a.地域 in (\'广东\',\'广东省\')) a
group by 日期,活跃度;