牛客907689258号

分类

/ 注册

全部文章（共28篇）

题解 | 对所有员工的薪水按照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 20

题解 | 获取所有非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 15

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

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 17

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

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

2026-01-14

0 19

题解 | 请写出计算粉丝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 21

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

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 12

题解 | 未完成试卷数大于1的有效用户

WITH t AS ( SELECT r.uid, CONCAT(DATE(r.start_time), ':', i.tag) AS detail_item, CASE WHEN r.submit_time IS NULL THEN 1 EL...

2026-01-13

0 19

题解 | 牛客直播各科目出勤率

WITH merged AS ( SELECT b.user_id, c.course_name, b.course_id, b.if_vw, b.if_fav, b.if_sign, ...

2026-01-12

0 15