eagle10

分类

/ 注册

全部文章（共29篇）

题解 | 输出播放量最高的视频

select cid,max(max_peak_uv) as max_peak_uv from (select t1.cid, sum(t1.tag) over ( partition by cid ...

2025-05-14

0 27

题解 | 更新员工信息表

select EMPLOYEE_ID, POSITION, LAST_UPDATE_DT from ( select EMPLOYEE_ID, POSITION, LAST_UPD...

2025-05-13

0 27

题解 | 牛客直播各科目同时在线人数

select t2.course_id,course_name,max(t2.num) from ( select t1.course_id, sum(flag) over ( partition by t1.course_id ...

2025-04-29

0 27

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

select * from ( select date (order_time) as dt, round( avg(count(start_time)) over ( o...

2025-04-17

0 31

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

with t1 as ( select tb_get_car_record.city, tb_get_car_order.driver_id, round(avg(grade), 1) as avg_gr...

2025-04-16

0 25

题解 | 某乎问答最大连续回答问题天数大于等于3天的用户及其对应等级

select t1.author_id,author_tb.author_level,t1.days_cnt from author_tb left join (SELECT sub.author_id, date_sub(sub.answer_date, interval sub.paimin...

2025-04-10

0 42

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

# 用户注册时间 WITH t1 AS ( SELECT TB.* ,T1.dt FROM tb_user_log TB LEFT JOIN ( SELECT t.uid, MIN(DATE(t.in_time)) AS dt FRO...

2025-04-08

0 40

题解 | 每篇文章同一时刻最大在看人数

SELECT artical_id,MAX(UV) AS max_uv FROM (SELECT artical_id,uid,dt, SUM(tag) OVER(PARTITION BY T1.artical_id ORDER BY dt ASC ,tag DESC ) AS UV FROM ...

2025-04-03

0 46

题解 | 用户订单信息查询

SELECT T1.city,T1.total_order_amount FROM ( SELECT C.customer_id,C.city,SUM(O.total_amount) AS total_order_amount FROM orders AS O LEFT JOIN custom...

2025-04-01

0 43

题解 | 被重复观看次数最多的3个视频

SELECT T2.cid,T2.pv,T2.rk FROM ( SELECT t1.cid, t1.pv, t1.release_date, ROW_NUMBER() O...

2025-03-31

0 35