题解 | SaaS平台企业客户新功能采纳度分析
SaaS平台企业客户新功能采纳度分析
https://www.nowcoder.com/practice/7b4b67320dde405c8ffdea850467a92d
with t1 as
(
select
team_id,
date(min(usage_timestamp)) as first_ever_usage_date
from feature_usage
group by 1
),
t2 as
(
select
team_id,
team_name,
count(*) as cnt
from feature_usage fu
left join teams t
using(team_id)
where plan_level = 'Enterprise'
and feature_name = 'Advanced_Analytics'
and usage_timestamp like '2025-04%'
group by 1,2
)
select
team_id,
team_name,
cnt as april_usage_count,
case when cnt > 50 then '深度采纳团队' else '普通采纳团队' end as adoption_category,
first_ever_usage_date
from t1
inner join t2
using(team_id)
order by 4 desc, 3 desc, 1 asc
查看4道真题和解析