不会真有人不想卷吧

题解

/ 注册

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

题解 | #工作日各时段叫车量、等待接单时间和调度时间#

select period, count(period)as get_car_num, round(avg(wait_time),1)as avg_wait_time, round(avg(dispatch_time),1)as avg_dispatch_time from (SELECT (cas...

Mysql

2021-12-05

0 239

题解 | #每天的日活数及新用户占比#

select dt,count(distinct t1.uid)as dau, round(count(t2.uid)/count(distinct t1.uid),2) as uv_new_ratio from (select uid,date(in_time)as dt from tb_user...

Mysql

2021-12-03

0 230

题解 | #连续签到领金币#

select uid,month,sum((case when nums%7>=3 then 2 else 0 end)+floor(nums/7)*8+nums)as coin from (select uid,date_format(d,'%Y%m')as month,coun...

Mysql

2021-12-03

1 242