少糖去冰啊_

分类

/ 注册

全部文章（共61篇）

题解 | 使用子查询的方式找出属于Action分类的所有电影对应的title,description

SELECT f.title, f.description FROM film f LEFT JOIN film_category fc on f.film_id=fc.film_id LEFT JOIN category c on fc.category_id = c.category_id WH...

2025-10-19

0 10

题解 | 使用join查询方式找出没有分类的电影id以及名称

SELECT f.film_id, f.title FROM film f LEFT JOIN film_category fc on f.film_id=fc.film_id LEFT JOIN category c on fc.category_id = c.category_id WHERE ...

2025-10-19

0 10

题解 | 汇总各个部门当前员工的title类型的分配数目

SELECT d2.dept_no, dept_name,t.title, count(*) as count FROM dept_emp d LEFT JOIN titles t on d.emp_no = t.emp_no LEFT JOIN departments d2 on d.dept_n...

2025-10-19

0 10

题解 | 对所有员工的薪水按照salary降序进行1-N的排名

SELECT emp_no, salary, dense_rank()over(order by salary desc) as t_rank FROM salaries

2025-10-19

0 11

题解 | 查找所有员工的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 11

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

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 12

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

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 13

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

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 14

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

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 10

题解 | 考试分数(一)

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

2025-10-17

0 15