白鸟予林

分类

/ 注册

全部文章（共6篇）

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

# 先对用户登录信息表login_tb去重，尽管该题说忽略单日多次登录情况，但现实中有可能单日多次登录 with QC as (select user_id,date_format(log_time,'%Y-%m-%d') t from login_tb ...

2025-03-09

0 29

题解 | 统计所有课程参加培训人次

select sum(if (course like '%course1%', 1, 0)) + sum(if (course like '%course2%', 1, 0)) + sum(if (course like '%course3%', 1, 0)) as st...

2025-03-09

0 36

ikun版本：最长连续登录天数

# 如果连续，则sing列的值一样 with ikun as (select user_id, fdate-row_number() over (partition by user_id order by fdate) sing from tb_dau where f...

2025-03-07

0 44

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

select u.room_id, room_name, count(distinct user_id) user_count from user_view_tb u join room_info_tb rap on u.room_id = rap.room_...

2025-03-03

0 58

题解 | 牛客的课程订单分析(七)

with ikun as ( select client_id, is_group_buy, count(*) over ( partition by ...

2025-02-25

0 36

题解 | 牛客的课程订单分析(五)

WITH sq AS ( SELECT user_id, date, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY date) AS rk, COUNT(*) OVER (PA...

2025-02-25

0 42