莫尔123

分类

/ 注册

全部文章（共4篇）

题解 | 考试分数(五)

select id,job,score,t_rank from (select id,job,score,row_number() over (partition by job order by score DESC) as t_rank, row_number() over (partition ...

2025-11-12

0 20

题解 | 饿了么需要分析不同配送员在不同天气条件下的配送效率和用户投诉情况

select weather_type, round(sum(sum_delivery)/sum(delivery_cnt),2) as average_delivery_time,sum(delivery_cnt) as delivery_count from (select b.weather_...

2025-07-27

1 33

题解 | #查询连续登陆的用户#

select distinct tmp1.user_id user_id from ( select lt.user_id user_id,date_add(date(log_time),interval 2 day) next_day, lead(date(log_time),2,...

2024-08-22

0 150

题解 | #每个月Top3的周杰伦歌曲#

select month,ranking,song_name,play_pv from (select pl_month month,row_number() over (partition by pl_month order by cnt DESC,song_id) ranking,so...

2024-08-22

12 231