select
team_id,
team_name,
sum(case when date_format(usage_timestamp,'%Y-%m')='2025-04' and feature_name = 'Advanced_Analytics' then 1 else 0 end) as april_usage_count,
case when count(*)>50 then '深度采纳团队' else '普通采纳团队' end as adoption_category,
date_format(min(usage_timestamp),'%Y-%m-%d') as first_ever_usage_date
from teams
join feature_usage
using(team_id)
group by team_id,team_name
order by adoption_category desc,april_usage_count desc,team_id