准备进厂的芹菜很伟大

分类

/ 注册

全部文章（共35篇）

题解 | 获取所有非manager的员工emp_no

SELECT e.emp_no FROM employees AS e LEFT JOIN dept_manager AS dept ON e.emp_no=dept.emp_no WHERE e.emp_no NOT IN (SELECT emp_no FROM dept_manager )

2025-12-27

0 57

题解 | 找出所有员工当前薪水salary情况

SELECT DISTINCT salary FROM salaries ORDER BY salary DESC

2025-12-27

0 57

题解 | 查找薪水记录超过15条的员工号emp_no以及其对应的记录次数t

SELECT emp_no ,COUNT(emp_no) AS t FROM salaries GROUP BY emp_no HAVING t>15

2025-12-27

0 45

题解 | 查找所有员工的last_name和first_name以及对应部门编号dept_no

SELECT e.last_name , e.first_name , d.dept_no FROM employees AS e LEFT JOIN dept_emp as d ON e.emp_no=d.emp_no

2025-12-27

0 50

题解 | 查找所有已经分配部门的员工的last_name和first_name以及dept_no

SELECT e.last_name , e.first_name , d.dept_no FROM employees AS e INNER JOIN dept_emp as d ON e.emp_no=d.emp_no WHERE e.emp_no IN ( SELECT emp_no FR...

2025-12-27

0 53

题解 | 查找当前薪水详情以及部门编号dept_no

SELECT s.emp_no, salary, from_date, s.to_date ,dm.dept_no FROM salaries AS s INNER JOIN dept_manager dm ON s.emp_no = dm.emp_no WHERE s.emp_no IN (SEL...

2025-12-27

0 55

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

select emp_no, birth_date, first_name, last_name, gender, hire_date from employees ORDER BY hire_date DESC LIMIT 1

2025-12-27

0 54

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

SELECT e.emp_id,emp_level,tag AS emp_tag FROM exam_record AS e JOIN examination_info AS ex ON e.exam_id = ex.exam_id JOIN em...

2025-04-22

0 86

题解 | 淘宝店铺的实际销售额与客单价

SELECT SUM(sales_num*goods_price)*1.000 AS sales_total , ROUND(SUM(sales_num*goods_price)/COUNT(DISTINCT user_id),3) AS per_trans FROM sales_tb AS s ...

2025-04-22

0 77

题解 | 短视频直播间晚上11-12点之间各直播间的在线人数

SELECT u.room_id,room_name,COUNT(DISTINCT user_id) AS user_count FROM user_view_tb AS u JOIN room_info_tb AS r on u.room_id = r.room_id where (time(i...

2025-04-22

0 79