希望offer多多的牛油很想去夏威夷

题解

/ 注册

全部文章 / 题解（共2篇）

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

select CONCAT(YEAR(submit_time),if(MONTH(submit_time)>=10,null,0),MONTH(submit_time)) month, round(count(distinct uid,day(submit_time))/count(disti...

Mysql

2022-03-16

0 273

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

select CONCAT(YEAR(submit_time),if(MONTH(submit_time)>=10,null,0),MONTH(submit_time)) month, round(count(distinct uid,day(submit_time))/count(disti...

Mysql

2021-10-30

24 762