mysql 同一分组不同条件统计（比如某个年级下所有班级的女生和男生）

select u.orga_id,o.name,sum(1) as '激活数',
sum(if(is_voide = 1,1,0) )as '听课数（人）' ,
sum(if(is_homework = 1,1,0)) as '写作业数（人）'
from ma_r_user u 
inner join ms_rc_organization o on u.orga_id = o.id
where  u.tenant_code='sduttsyxy'   group by u.orga_id