在午休的伊泽瑞尔很想吃火锅

分类

/ 注册

全部文章（共6篇）

题解 | 支付间隔平均值

with t1 as ( select order_log.order_id, order_log.time as or_time, select_log.time as sel_time, abs(timestampdiff(second,order_l...

2025-06-25

0 50

题解 | 统计每个产品的销售情况

with t1 as( select cu.customer_id, customer_age, order_id, product_id, quantity, order_date f...

2025-06-25

0 55

题解 | 最长连续登录天数

with t1 as ( select user_id, row_number() over(partition by user_id order by fdate) as rk, date_sub(fdate, interval (row_number() ov...

2025-06-25

0 51

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

with t1 as ( select user_id, date(log_time) as date_time, ROW_NUMBER() over (partition by user_id) as rk from login_tb ) , t2 as ( select user_id,...

2025-06-25

0 52

题解 | 完成员工考核试卷突出的非领导员工

with t1 as ( select emp_id, exam_id, score, AVG(score) over(partition by exam_id) as avg_sco, timestampdiff(second, start_tim...

2025-06-24

0 75

题解 | 完成员工考核试卷突出的非领导员工

with t1 as ( select emp_id, exam_id, score, AVG(score) over(partition by exam_id) as avg_sco, timestampdiff(second, start_tim...

2025-06-24

1 85