月报表统计解决方法

select count(*),bumen.name from bumen inner join in xinwen on bumen.branchid=xinwen.branchiid group by bumen.name

------解决方案--------------------

按部门分组，Count(NewsID)