壹壹风荷举

分类

/ 注册

全部文章（共61篇）

题解 | 更新用户积分信息？

with temp as (select user_id,sum( order_price) as add_point from order_tb where order_price>100 group by user_id) select t.user_id,add_point+point...

2025-09-15

0 26

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

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 29

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

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 17

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

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 21

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

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 29

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

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

2025-09-13

1 22

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

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 21

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

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

2025-09-13

1 30

题解 | 最长连续登录天数

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

2025-09-13

1 30

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

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

2025-09-13

1 18