34,590
社区成员
发帖
与我相关
我的任务
分享
select a.grbh,b.xm,count(a.grbh) as '活动次数',sum(b.htsj) as '累计活动时间'
from htjl a join ryxx b on a.grbh=b.grbh
where b.xm='男'
group by a.grbh,b.xm
select a.xm,
sum(case when b.grbh is null then 0 else 1 end) as 累计活动次数,sum(b.htsj) as 累计活动时间
from ryxx a left join htjl b on a.grbh = b.grbh
group by a.xm
select sum(case when b.grbh is null then 0 else 1 end) as 累计活动次数,sum(b.htsj) as 累计活动时间
from ryxx a left join htjl b on a.grbh = b.grbh
group by a.xm
select a.grbh,b.xm,count(a.grbh) as '活动次数',sum(b.htsj) as '累计活动时间'
from htjl a join ryxx b on a.grbh=b.grbh
group by a.grbh,b.xm
select a.grbh,b.xm count(a.grbh) as '活动次数',sum(b.htsj) as '累计活动时间'
from htjl a join ryxx b on a.grbh=b.grbh
group by a.grbh,b.xm