select count(),
count(if tmp.t>1, 1,null),
count()/count(if tmp>1 1,null) result
from
(
select userid,count(*) t
from order
group by userid
) tmp
复购率
最新推荐文章于 2024-01-06 12:18:57 发布
select count(),
count(if tmp.t>1, 1,null),
count()/count(if tmp>1 1,null) result
from
(
select userid,count(*) t
from order
group by userid
) tmp