Lateral

分类

/ 注册

全部文章（共115篇）

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

select t.user_id as user_id from (select l.user_id, date(l.log_time) as log_day, row_number() over(partition by l.user_id order by date(l.log_time) de...

2025-03-04

0 47

题解 | 每个商品的销售总额

select t.product_name, t.total_sales, row_number() over(partition by t.category order by t.total_sales desc,t.product_id asc) as category_rank from (s...

2025-03-03

0 58

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

select sum(distinct u.score)/count(distinct u.score) as avg_score from recommend_tb r left join user_action_tb u on u.user_id=r.rec_user where r.rec...

2025-03-03

0 40

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

select c.staff_id, s.staff_name from cultivate_tb c left join staff_tb s on c.staff_id=s.staff_id where c.course like '%course3%'

2025-03-03

21 46

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

select sum(t1.c1_nums)+ sum(t1.c2_nums)+ sum(t1.c3_nums) as staff_nums from (select staff_id, case when instr(c.course,'1')!=0 then 1 else 0 end a...

2025-03-03

0 59