题解 | #计算每天的新用户占比#

select login_date as dt,
       count(distinct t1.uid) as total_user_num,
       concat(round(count(case when login_date=md then 1 else null end ) / count(distinct t1.uid) * 100 , 1), '%') as new_user_rate
from
(select * from  user_login_tb) t1
right join
(select uid, min(login_date) md from user_login_tb group by uid) t2
on t1.uid = t2.uid
group by login_date