谦虚的比尔在炒股

分类

/ 注册

TA的专栏 0篇文章 0人订阅

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共138篇）

题解 | 牛客每个人最近的登录日期(五)

select l1.date, ifnull(round(count(distinct l3.user_id) / count(l2.user_id),3),0) as p from ( select date from login ...

2026-01-16

0 50

题解 | 网易云音乐推荐(网易校招笔试真题)

with 1_follows_like as ( select f.user_id, ml.music_id from follow as f left join music_likes as ml ...

2026-01-16

0 48

题解 | 获得积分最多的人(三)

with new_grade_info as ( select user_id, case when type = 'add' then grade_num when type = 'reduce' then (...

2026-01-16

0 52

题解 | 最差是第几名(二)

with sum_class_grade as ( select grade, (select sum(number) from class_grade) as total, sum(number) over (order by grade) ...

2026-01-16

0 66

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

with flitered_order_info as ( select *, count(user_id) over (partition by user_id) as cnt from order_info where ...

2026-01-16

0 47

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

with flitered_order_info as ( select *, count(*) over (partition by user_id) as cnt from order_info where ...

2026-01-14

0 41

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

with flitered_order_info as ( select *, count(*) over (partition by user_id) as cnt, row_number() over (partition by user_...

2026-01-14

0 39

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

with flitered_order_info as ( select *, count(*) over (partition by user_id) as cnt from order_info where ...

2026-01-14

0 47

题解 | 考试分数(四)

with grade_num as ( select job, count(job) as cnt from grade group by job ) select job, case ...

2026-01-13

0 44

题解 | 考试分数(三)

with grade_rank as ( select *, dense_rank() over (partition by language_id order by score desc) as rn from grade ) ...

2026-01-13

0 41