题解 | #平均活跃天数和月活人数#

平均活跃天数和月活人数

https://www.nowcoder.com/practice/9e2fb674b58b4f60ac765b7a37dde1b9

select date_format(submit_time,'%Y%m') `month`,
	round(count(distinct concat(uid, date_format(submit_time,'%Y%m%d')))/
	count(distinct uid),2) avg_active_days,
	round(count(distinct uid),2) mau
from exam_record
where year(submit_time) = '2021'
group by date_format(submit_time,'%Y%m');

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务