wenzo_

分类

/ 注册

全部文章（共31篇）

题解 | 获取员工其当前的薪水比其manager当前薪水还高的相关信息

# 当前 WHERE to_date = '9999-01-01' # 员工薪水比manager薪水高(条件1：同一部门，条件2：员工薪水更高) SELECT emp_no, manager_no, emp_salary, manager_salary FROM( ...

2025-02-24

0 37

题解 | 获取所有非manager员工当前的薪水情况

SELECT de.dept_no, e.emp_no, salary FROM employees e # join 就完事儿了 JOIN dept_emp de ON e.emp_no = de.emp_no JOIN dept_manager dm ON de.dept...

2025-02-24

0 48

题解 | 查找在职员工自入职以来的薪水涨幅情况

SELECT emp_no, end_sal - start_sal AS growth # 工资差 FROM( SELECT e.emp_no, salary AS start_sal, # 入职工资 end_sal # 当前...

2025-02-24

0 44

题解 | 商品销售总额分布

SELECT IF(pay_method = '', 'error', pay_method), COUNT(pay_method) AS cnt FROM user_client_log u JOIN product_info p ON u.product_id = p.produ...

2025-02-14

0 45

题解 | 商品销售排名

SELECT product_name, COUNT(step) * price AS total_sales FROM user_client_log u JOIN product_info p ON u.product_id = p.product_id WHERE step =...

2025-02-14

2 43

题解 | 商品价格排名

SELECT product_id, product_name, type, price FROM( SELECT product_id, product_name, type, price, ...

2025-02-14

0 48

题解 | 完成员工考核试卷突出的非领导员工

SELECT emp_id, emp_level, exam_tag FROM( SELECT er.emp_id, er.exam_id, emp_level, ROUND(TIMESTAMPDIFF(...

2025-02-14

0 36

题解 | 被重复观看次数最多的3个视频

SELECT cid, pv, ROW_NUMBER() OVER(ORDER BY pv DESC, release_date DESC) AS rk # 3. 排名，注意顺序 FROM( SELECT cid, release_da...

2025-02-13

0 37

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

SELECT DISTINCT music_name # 去重 FROM music m JOIN( SELECT DISTINCT ml.user_id, music_id FROM music_likes ml JOIN( ...

2025-02-13

0 32

题解 | 支付间隔平均值

SELECT CAST(ROUND(AVG(ABS(TIMESTAMPDIFF(SECOND, o_logtime, s_logtime)))) AS SIGNED) AS gap FROM( SELECT o.order_id, o.logtime ...

2025-02-13

0 59