海阔天空alphabetago

分类

/ 注册

全部文章（共17篇）

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

SELECT -- music.id, music.music_name FROM follow JOIN music_likes ON follow.follower_id = music_likes.user_id JOIN mu...

2023-10-09

0 142

题解 | #商品交易(网易校招笔试真题)#

SELECT ta.goods_id AS id , goods.name AS name , goods.weight AS weight , total AS total FROM ( SELECT goods_id, ...

2023-10-09

0 130

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

SELECT tt.user_id, user.name, tt.sum_num FROM ( SELECT * , DENSE_RANK() OVER( ORDER BY sum_num DESC ) AS rk ...

2023-10-09

0 108

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

SELECT tt.user_id, user.name, tt.sum_num FROM ( SELECT * , DENSE_RANK() OVER( ORDER BY sum_num DESC ) AS rk ...

2023-10-09

0 151

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

SELECT user.name, SUM(grade_num) OVER( PARTITION BY user_id ) AS total_num FROM grade_info JOIN user ...

2023-10-08

0 132

题解 | #查找入职员工时间排名倒数第三的员工所有信息#

SELECT `emp_no` ,`birth_date` ,`first_name` ,`last_name` ,`gender` ,`hire_date` FROM ( SELECT *...

2023-10-08

0 95

题解 | #查找最晚入职员工的所有信息#

SELECT `emp_no` ,`birth_date` ,`first_name` ,`last_name` ,`gender` ,`hire_date` FROM ( SELECT *...

2023-10-08

0 103

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

SELECT resume_2025.*, resume_2026.mon, resume_2026.num FROM ( SELECT job, substr(date, 1, 7) AS mon, sum...

2023-10-08

0 91

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

SELECT job, substr(date, 1, 7) AS mon, sum(num) FROM resume_info WHERE substr(date, 1, 4) = '2025' GROUP BY substr(date, ...

2023-10-08

0 114

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

SELECT COALESCE(name, 'GroupBuy') AS source ,COUNT(*) AS cnt FROM ( SELECT order_info.id AS id, order_info.is_group_b...

2023-10-08

0 150