总坐高见

分类

/ 注册

全部文章（共19篇）

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

方法一：使用 like 筛选 select s.staff_id,s.staff_name from staff_tb s inner join cultivate_tb c on s.staff_id = c.staff_id where course is not null and course...

2025-08-21

0 13

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

解法一： with t_base as ( select month(fdate) as month,user_id,song_id from play_log where song_id in (select song_id from song_info where singer_name='周杰...

2025-08-16

0 18

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

with t_base as ( select u.id,name, sum(g.grade_num) as total from user u inner join grade_info g on u.id=g.user_id where g.type='add' group by u.id...

2025-08-15

0 16

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

方法一： with t_2025 as ( select job,date_format(date,'%Y-%m') as month,sum(num) as sum from resume_info where year(date)=2025 group by month,job ), t_20...

2025-08-14

0 20

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

方法一： with t_base as ( select id,user_id,client_id,is_group_buy,cnt from (select id,user_id,product_name,status,client_id,date,is_group_buy, count(*) ...

2025-08-13

0 15

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

方法一：用case when with t_base as ( select id,user_id,product_name,status,client_id,date,is_group_buy, cnt from (select id,user_id,product_name,status,cli...

2025-08-13

0 16

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

方法一：用min()和max()确定第一名和第二名，我感觉这种不是最好的方法，如果需要确定第三名、第四名，用这种方法就不好实现了。 with base_table as ( select id,user_id,product_name,status,client_id,date, row_numbe...

2025-08-13

0 21

题解 | 考试分数(五)

-- 方法一 with ranked_data as ( select id, job, score, dense_rank() over ( pa...

2025-08-08

0 19

题解 | 考试分数(五)

with ranked_data as ( select id, job, score, dense_rank() over ( partition...

2025-08-07

0 14