eagle10

分类

/ 注册

全部文章（共17篇）

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

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 6

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

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

2025-04-17

0 14

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

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 12

题解 | 某乎问答最大连续回答问题天数大于等于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 16

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

# 用户注册时间 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 18

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

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 22

题解 | 用户订单信息查询

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 22

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

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

2025-03-31

0 20

题解 | 返回顾客名称和相关订单号以及每个订单的总价

select cust_name,order_num, quantity*item_price as OrderTotal from OrderItems left join Orders using(order_num) left join Customers using(cust_id) ord...

2025-03-25

0 23

题解 | 查询订单

select t1.order_id,t1.customer_name,t1.order_date from( select orders.order_id ,customers.customer_name, orders.order_date,rank() over(partition by o...

2025-03-20

0 23