纯真的我求求offer

分类

/ 注册

全部文章（共40篇）

题解 | #每个城市中评分最高的司机信息#

select f.city, f.driver_id, format(avg_socre,1) avg_grade, format(count(e.order_id)/count(distinct date_format(e.order_time,'%Y%m%d')),1) avg_order_n...

2023-09-10

0 219

题解 | #各城市最大同时等车人数#

select city, max(cnt_all) max_wait_uv from ( select *, sum(cnt) over(partition by city,date(dt) order by dt,cnt desc) cnt_all from ...

2023-09-09

0 163

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

select period, count(distinct id) get_car_num, round(sum(wait_time)/count(wait_time)/60,1) avg_wait_time, round(sum(dispatch_time)/count(case when dis...

2023-09-09

0 157

题解 | #有取消订单记录的司机平均评分#

with tmp as ( select driver_id from tb_get_car_order where date_format(order_time,'%Y%m')='202110' and start_time is null ) ...

2023-09-09

0 147

题解 | #国庆期间近7日日均取消订单量#

select dt, round(finish_num_7d/7,2) finish_num_7d, round(cancel_num_7d/7,2) cancel_num_7d from ( select *, sum(finish) over(order by dt range int...

2023-09-09

0 215

题解 | #牛客直播开始时各直播间在线人数#

select a.course_id, b.course_name, count(distinct a.user_id) online_num from attend_tb a left join course_tb b on a.course_id=b.course_id where dat...

2023-09-09

0 118

题解 | #牛客直播转换率#

select a.course_id, b.course_name , format(count(distinct case when if_sign=1 then user_id end)/count(distinct case when if_vw=1 then user_id end)*10...

2023-09-09

0 140

题解 | #对试卷得分做min-max归一化#

select uid,exam_id, -- case when round(sum(guiyi)/count(case when guiyi<>0 then guiyi else null end),0) is not null -- then round(sum(guiyi)/c...

2023-09-07

0 200

题解 | #每月及截止当月的答题情况#

select *, max(month_add_uv) over (order by mon) as max_month_add_uv, sum(month_add_uv) over (order by mon) cum_sum_uv from ( select date_format(...

2023-09-07

1 222

题解 | #每份试卷每月作答数和截止当月的作答总数。#

select exam_id, start_month, month_cnt, sum(month_cnt) over (partition by exam_id order by start_month ) cum_exam_cnt from ( select exam_id, ...

2023-09-07

0 211