select tmp.sex,avg(tmp.ct) from
(
select userid,sex,count(1) as ct from order o
join
user u
on o.userid=u.userid
group by userid,sex
) tmp
group by tmp.sex
男女不同的消费频次
最新推荐文章于 2021-11-25 11:50:55 发布
select tmp.sex,avg(tmp.ct) from
(
select userid,sex,count(1) as ct from order o
join
user u
on o.userid=u.userid
group by userid,sex
) tmp
group by tmp.sex