踏实的安德鲁加麻加辣

分类

/ 注册

全部文章（共5篇）

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

with tmp as( select t_o.customer_id,t_o.product_id,t_o.quantity, case when t_c.customer_age between 1 and 10 then '1-10' when...

2025-12-21

1 32

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

with tmp as (select a.exam_id,b.avg_time,a.avg_score from( select exam_id,avg(score) avg_score from exam_record group by exam_id )as a left joi...

2025-12-07

1 25

题解 | 查询连续入住多晚的客户信息？

with tmp as( select t1.user_id,t1.continue_day,t2.room_id from( select user_id,datediff(checkout_time,checkin_time) continue_day from checkin_tb where...

2025-11-30

1 19

题解 | 最长连续登录天数

with t as( select user_id,count(continue_day)as console_day from( select user_id,date_sub(fdate,interval row_number() over(partition by user_id)day) c...

2025-11-30

1 21

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

with a as( --创建临时表，用于进行查询top3的操作 select month(t1.fdate) as month,t3.song_id, t3.song_name song_name,count(*) play_pv fro...

2025-11-09

1 52