又被画饼了的牛可乐很热血

分类

/ 注册

全部文章（共4篇）

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

SELECT DISTINCT r.user_id FROM register_tb r JOIN login_tb a ON r.user_id = a.user_id JOIN login_tb b ON r.user_id = b.user_id AND DATEDIFF(DATE(...

2025-07-07

1 81

题解 | 查询培训指定课程的员工信息

select s.staff_id,s.staff_name from staff_tb s join cultivate_tb c using(staff_id) where c.course like '%3%'

2025-07-04

2 65

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

select c.user_id,c.room_id,g.room_type,datediff(c.checkout_time,c.checkin_time) days from checkin_tb c join guestroom_tb g using(room_id) where datedi...

2025-07-04

1 80

题解 | 最长连续登录天数

with fdate_rnk as ( select fdate,user_id,row_number()over(partition by user_id order by fdate) rnk from tb_dau where fdate between '2023-01-01' a...

2025-07-04

1 63