热情的悲伤蛙求求offer

分类

/ 注册

全部文章（共25篇）

题解 | 链表内指定区间反转

# class ListNode: # def __init__(self, x): # self.val = x # self.next = None # # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param...

2025-05-07

0 11

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

# 目标输出city,driver_id,avg_grade,avg_order_num,avg_mileage with t as( select r.city,o.driver_id, round(avg(o.grade),1) as avg_grade, round...

2025-05-07

0 13

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

# 找到这些司机完成订单 dirver_id,order_id,grade with a as( select o.driver_id,o.order_id,o.grade from tb_get_car_order as o where o.driver_id in ( ...

2025-05-07

0 9

题解 | 10月的新户客单价和获客成本

# 链接表，得到uid,order_id,total_amount,total-zong with t as ( select x.uid,z.order_id,o.total_amount,z.zong-o.total_amount as cost from ( ...

2025-05-07

0 12

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

# 找到每天的新用户t1 根据uid分组，得到每个uid的最早活跃时间 select uid,min(date_format(in_time,'%Y-%m-%d')) as zuizao from tb_user_log group by uid # 找到每天活跃的用户t2 根据union合并去重...

2025-04-22

0 17