牛客907689258号

分类

/ 注册

全部文章（共32篇）

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

SELECT t1.dept_no, dept_name, title, COUNT(title) AS count FROM departments t1 LEFT JOIN dept_emp t2 USING (dept_no) LEFT JOIN titles t3 USING (emp_no...

2026-01-18

0 39

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

SELECT emp_no, salary, DENSE_RANK() OVER ( ORDER BY salary DESC ) AS salary_rank FROM salaries WHERE to_date = '9999-01-01' OR...

2026-01-18

0 31

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

select e.last_name, e.first_name, dm.dept_name from employees e left join dept_emp d on e.emp_no = d.emp_no left join departme...

2026-01-18

0 40

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

WITH dept_emp_salary AS ( SELECT d.emp_no, d.dept_no, d.from_date AS dept_from_date, d.to_date AS dept_to_date, ...

2026-01-18

0 41

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

SELECT emp_no, salary, DENSE_RANK() OVER ( ORDER BY salary DESC ) AS salary_rank FROM salaries WHERE to_date = '9999-01-01' OR...

2026-01-18

0 55

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

SELECT de.dept_no, de.emp_no, s.salary FROM dept_emp de LEFT JOIN dept_manager dm ON de.emp_no = dm.emp_no JOIN salaries s ON de.e...

2026-01-18

0 41

题解 | 分析每个商品在不同时间段的销售情况

SELECT product_id, p.product_name, SUM( CASE WHEN o.order_date BETWEEN '2024-04-01' AND '2024-06-30' THEN o.total_amount E...

2026-01-14

0 42

题解 | 统计每个产品的销售情况

WITH order_full_cte AS ( SELECT * FROM orders o LEFT JOIN customers c USING (customer_id) LEFT JOIN products p...

2026-01-14

0 37

题解 | 请写出计算粉丝ctr的sql语句

select sum(read_num)/sum(show_num) as fans_ctr from a join b using(author_id) join c using(content_id, fans_id)

2026-01-14

0 45

题解 | 更新用户积分信息？

SELECT o.user_id, point + SUM(order_price) AS point FROM order_tb o JOIN uservip_tb u ON o.user_id = u.user_id WHERE order_price > 100 GRO...

2026-01-14

0 35