谦虚的比尔在炒股

分类

/ 注册

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

sql练习-面试前刷题

0篇文章 0人学习

全部文章（共129篇）

题解 | 实习广场投递简历分析(三)

with 2025_resume as ( select job, substr(date,1,7) as first_year_mon, sum(num) as first_year_cnt from resume_...

2026-01-19

0 16

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

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 13

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

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 16

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

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

2026-01-16

0 13

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

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 16

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

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

2026-01-16

0 14

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

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

2026-01-14

0 16

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

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

2026-01-14

0 14

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

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

2026-01-14

0 17

题解 | 考试分数(四)

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

2026-01-13

0 16