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
mysql 同一分组不同条件统计(比如某个年级下所有班级的女生和男生)
最新推荐文章于 2024-07-31 12:54:28 发布