踏实的安德鲁加麻加辣
踏实的安德鲁加麻加辣
全部文章
分类
归档
标签
去牛客网
登录
/
注册
踏实的安德鲁加麻加辣的博客
全部文章
(共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