壹壹风荷举

分类

/ 注册

全部文章（共80篇）

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

with temp as (select date(visit_time) as date_visit,count(distinct user_id) as visit_count from visit_tb group by date(visit_time) ), temp2 as ( ...

2025-09-15

0 42

题解 | 查询下订单用户访问次数？

SELECT user_id, COUNT(*) as visit_nums FROM visit_tb WHERE user_id IN ( SELECT DISTINCT user_id FROM order_tb WHERE DATE(order_time) = '20...

2025-09-15

0 22

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

with temp as ( select user_id,log_date, case when datediff(log_date,lag(log_date,1,log_date) over(partition by user_id order by log_date)) >...

2025-09-14

1 24

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

with temp as ( select user_id,log_date, case when datediff(log_date,lag(log_date,1,log_date) over(partition by user_id order by log_date)) >...

2025-09-14

2 40

题解 | 推荐内容准确的用户平均评分

with temp as ( select distinct user_id, score from recommend_tb r join user_action...

2025-09-13

1 27

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

SELECT s.staff_id, s.staff_name FROM staff_tb AS s JOIN cultivate_tb AS c ON s.staff_id = c.staff_id WHERE c.course LIKE '%course3...

2025-09-13

1 26

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

select sum( case when course is null then 0 else length(course) - length( replace ...

2025-09-13

1 37

题解 | 最长连续登录天数

with temp as ( SELECT user_id, fdate, row_number() over ( partition by ...

2025-09-13

1 39

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

with temp as ( select month(fdate) as month, count(p.song_id) as play_pv, song_name, row_n...

2025-09-13

1 23

题解 | 浙大不同难度题目的正确率

select difficult_level, sum( case when result = 'right' then 1 else 0 end ) / count(q1.question_id...

2025-09-11

1 17