22,300
社区成员




with t
as(
select
a.userid,
orgname
from
部门表 a
inner join
部门信息表 b
on
a.orgid=b.orgid
)
select
t.orgname,
u.username,
COUNT(c.content) as [count]
from
t
inner join
用户表 u
on
t.userid=u.userid
inner join
日记表 c
on
t.userid=content.userid
group by
t.orgname,
u.username
select di.orgname,u.username,count(1) [count]
from 用户表 u inner join 部门表 D on u.userid=d.userid
inner join 部门信息表 DI on d.orgid=di.orgid
inner join 日记表 l on u.userid=l.userid
group by di.orgname,u.username