牛客907689258号

分类

/ 注册

全部文章（共28篇）

题解 | 查找后多列排序

select device_id, gpa, age from user_profile order by gpa ASC, age ASC;

2026-01-23

0 13

题解 | 计算用户的平均次日留存率

WITH base AS ( SELECT device_id, practice_date, LEAD(practice_date) OVER ( PARTITION BY device_id ...

2026-01-22

0 15

题解 | 计算用户的平均次日留存率

WITH base AS ( SELECT device_id, DATE(date) AS practice_date, RANK() OVER ( PARTITION BY device_id ...

2026-01-22

0 15

题解 | 查询出不同类别商品中，销售金额排名前三且利润率超过 20%的商品信息

WITH product_sales AS ( SELECT t1.product_id, t1.product_name, t1.category_id, SUM(t2.sales_amount) AS sales_amoun...

2026-01-20

0 17

题解 | 得分不小于平均分的最低分

WITH ranked_scores AS ( SELECT t1.score, t2.tag, RANK() OVER ( ORDER BY ...

2026-01-19

0 18

题解 | 每天的日活数及新用户占比

WITH first_login AS ( SELECT uid, MIN(DATE(in_time)) AS first_login_time FROM tb_user_log ...

2026-01-19

0 13

题解 | 汇总各个部门当前员工的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 18

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

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

题解 | 获取员工其当前的薪水比其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 17