牛客161357542号

分类

/ 注册

全部文章（共11篇）

题解 | #零食类商品中复购率top3高的商品#

-- 1、求出近90天内所有购买零食类商品的信息 WITH t AS ( SELECT d.product_id,event_time,uid FROM tb_order_overall o JOIN tb_order_detail d ON o.order_id=d.order_id JOIN t...

2023-09-26

1 170

题解 | #某店铺的各商品毛利率及店铺整体毛利率#

WITH t AS( SELECT shop_id,d.product_id,in_price,cnt,price FROM tb_order_overall o JOIN tb_order_detail d ON o.order_id=d.order_id JOIN tb_product_inf...

2023-09-26

0 101

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

-- 1、所有数据（完成、用户取消、司机取消等。注意：LEFT JOIN ） WITH t AS ( SELECT city, event_time in_t, -- 开始打车时间 IF(fare IS NULL,end_time,start_time) out_t -- 停止等待时间 FR...

2023-09-25

0 126

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

WITH t AS ( SELECT CASE WHEN TIME(event_time)>='07:00:00' AND TIME(event_time)<'09:00:00' THEN '早高峰' WHEN TIME(event_time)>='09:00:00' AND ...

2023-09-25

0 106

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

WITH t AS ( SELECT DATE(order_time) dt, ROUND(SUM(COUNT(fare))OVER(ORDER BY DATE(order_time) RANGE INTERVAL 6 DAY PRECEDING)/7,2) finish_num_7d, ROUND...

2023-09-25

0 139

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

WITH t AS ( SELECT city,driver_id,ROUND(AVG(grade),1) avg_grade, ROUND(COUNT(*)/COUNT(DISTINCT DATE(order_time)),1) avg_order_num, ROUND(SUM(mileage)/...

2023-09-25

0 106

题解 | #进制间转换#

def convert(num,bit): if num == 0: return 0 temp = [] while(num//bit>=bit): temp.append(num%bit) num = num//bit...

2023-09-23

0 163

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

-- 1、找到每个日子的近7日的订单完成数和取消订单数 with t as ( select date(order_time) dt, sum(count(mileage))over(order by date(order_time) range interval 6 day pre...

2023-08-16

0 170

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

with t as ( -- 2、将各城市司机根据当前城市排名dense_rank select city,driver_id,dense_rank()over(partition by city order by avg_grade desc) dr from ( --...

2023-08-16

0 350

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

select if(grouping(driver_id)=0,driver_id,'总体'), round(avg(grade),1) from tb_get_car_order where grade is not null -- 2、有评价的订单 and driver_id in (sel...

2023-08-16

0 237