少糖去冰啊_

分类

/ 注册

全部文章（共67篇）

题解 | 查找所有员工的last_name和first_name以及对应的dept_name

SELECT last_name, first_name, dept_name FROM employees e LEFT JOIN dept_emp d1 on e.emp_no = d1.emp_no LEFT JOIN departments d2 on d1.dept_no = d2.dep...

2025-10-19

0 17

题解 | 获取每个部门中薪水最高的员工相关信息

SELECT dept_no, d.emp_no, salary FROM dept_emp d LEFT JOIN salaries s on d.emp_no=s.emp_no WHERE (dept_no, salary) in (SELECT dept_no, max(salary) FR...

2025-10-17

0 19

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

SELECT job, sum(num) as cnt FROM resume_info r WHERE r.date like '2025%' GROUP BY job ORDER BY cnt desc

2025-10-17

0 21

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

SELECT g.id, g.name, g.weight, sum(t.count) as total FROM goods g LEFT JOIN trans t on g.id = t.goods_id WHERE g.weight<50 GROUP BY g.id HAVING tot...

2025-10-17

0 18

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

SELECT g.id, g.name, g.weight, sum(t.count) as total FROM goods g LEFT JOIN trans t on g.id = t.goods_id WHERE g.weight<50 GROUP BY g.id HAVING tot...

2025-10-17

0 17

题解 | 考试分数(一)

SELECT job, round(AVG(score),3) as avg FROM grade GROUP BY job ORDER BY avg desc

2025-10-17

0 22

题解 | 找到每个人的任务

SELECT p.id, p.name, content FROM person p LEFT JOIN task t on p.id = t.person_id ORDER BY p.id asc;

2025-10-17

0 18

题解 | 将所有获取奖金的员工当前的薪水增加10%

UPDATE salaries s SET s.salary = 1.1*s.salary WHERE s.to_date = '9999-01-01' AND s.emp_no IN (SELECT emp_no FROM emp_bonus)

2025-10-17

0 19

题解 | 将employees表的所有员工的last_name和first_name拼接起来ame

SELECT concat(last_name,' ',first_name) as Name FROM employees

2025-10-17

0 13

题解 | 统计各个部门的工资记录数

SELECT d2.dept_no, dept_name, count(salary) as sum FROM dept_emp d1 LEFT JOIN departments d2 on d1.dept_no = d2.dept_no INNER JOIN salaries s on d1.em...

2025-10-17

0 20