芒勾
芒勾
全部文章
分类
题解(21)
归档
标签
去牛客网
登录
/
注册
芒勾的博客
全部文章
(共19篇)
题解 | #获取有奖金的员工相关信息。#
/* SELECT e.emp_no as emp_no, e.first_name as first_name, e.last_name as last_name, bonus.btype as btype FROM employees as e left join emp_bonus as bo...
Mysql
2021-09-24
0
293
题解 | #获得积分最多的人(三)#
/* select info.user_id, u.name, sum(case when info.type = 'add' then info.grade_num * 1 when info.type = 'reduce' then info.grade_num * (-1...
Mysql
2021-09-23
0
255
题解 | #获得积分最多的人(一)#
/* SELECT u.name, sum(info.grade_num) as grade_sum from user as u right JOIN grade_info as info ON u.id = info.user_id GROUP BY info.user_id */ SELEC...
Mysql
2021-09-23
0
275
题解 | #最差是第几名(二)#
/* SELECT grade, sum(number) over(order by grade) FROM class_grade; SELECT grade, sum(number) over(order by grade desc) FROM class_grade */ SELECT t...
Mysql
2021-09-23
0
247
题解 | #实习广场投递简历分析(三)#
/* SELECT job, DATE_FORMAT(date, "%y-%m") FROM resume_info as info WHERE YEAR(date) = 2025 GROUP BY MONTH(date), job SELECT job, DATE_FORMA...
Mysql
2021-09-23
0
250
题解 | #牛客的课程订单分析(七)#
/* SELECT user_id FROM order_info WHERE date > '2025-10-15' and product_name in ('Java', 'C++', 'Python') and status = 'completed' GROUP BY user_id...
Mysql
2021-09-23
0
235
题解 | #牛客的课程订单分析(七)#
/* SELECT user_id FROM order_info WHERE date > '2025-10-15' and product_name in ('Java', 'C++', '...
Mysql
2021-09-23
0
227
题解 | #牛客的课程订单分析(五)#
/* #第二次购买日期 select t.user_id as user_id, 1, t.date as second_buy_date, max(t.r) as cnt from(SELECT *, rank()over(PARTITION by user_id order by date) a...
Mysql
2021-09-23
0
309
题解 | #牛客的课程订单分析(四)#
SELECT user_id, min(date) as first_buy_date, COUNT(*) as cnt FROM order_info as info where date > '2025-10-15' and status = 'completed' and product...
Mysql
2021-09-23
0
237
题解 | #牛客的课程订单分析(三)#
/* SELECT user_id FROM order_info where date > '2025-10-15' and product_name in ('C++', 'Java', 'Python') and status = 'completed' GROUP BY user_id...
Mysql
2021-09-23
0
298
首页
上一页
1
2
下一页
末页