木流_牛马

分类

/ 注册

全部文章（共23篇）

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

with T1 as ( select * from user_view_tb u where (u.in_time between '23:00:00' and '23:59:59') or (u.out_time between '23:00:00' and ...

2025-03-28

1 34

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

with T1 as( select l.user_id as user_id, date(l.log_time) as logdate1, lead(date(l.log_time),1)over(partition by l.user_id order by l.log_...

2025-03-27

1 29

题解 | 统计用户从访问到下单的转化率

with T1 as ( select date(o.order_time) as day,count(distinct(o.user_id)) as orderdone from order_tb o group by (date(o.order_time)) ),T2 a...

2025-03-27

1 37