题解 | #不同学校类型的三日留存率#
不同学校类型的三日留存率
https://www.nowcoder.com/practice/af51f1334b814e6caa512483a60485d2
select
school_type
,sum(3daycnt)/sum(uidcnt) as trdays
from ad_channel_register_retention_uid
group by 1
order by 2 desc
不同学校类型的三日留存率
https://www.nowcoder.com/practice/af51f1334b814e6caa512483a60485d2
select
school_type
,sum(3daycnt)/sum(uidcnt) as trdays
from ad_channel_register_retention_uid
group by 1
order by 2 desc
相关推荐