牛客63343748号

分类

/ 注册

全部文章（共39篇）

题解 | 牛客的课程订单分析(四)

select user_id, min(date), count(*) as cnt from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++'...

2025-04-17

0 42

题解 | 牛客的课程订单分析(二)

select user_id from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python') group by user_...

2025-04-17

0 33

题解 | 牛客的课程订单分析(一)

select * from order_info where date>'2025-10-15' and status='completed' and product_name in('C++','Java','Python') order by id;

2025-04-17

0 27

题解 | 牛客每个人最近的登录日期(四)

select l2.date, count(l1.date1) as new from login as l2 left join ( select user_id, date as date1, ...

2025-04-15

0 34

题解 | 牛客每个人最近的登录日期(三)

with a as ( select distinct user_id, date, dense_rank() over(partition by user_id order by date) as date_rank from login ), b as ( select...

2025-04-15

0 29

题解 | 牛客每个人最近的登录日期(二)

select a.u_n, a.c_n, a.date from ( select u.name as u_n,c.name as c_n,date,row_number() over(partition by user_id order by date desc) as...

2025-04-14

0 20

题解 | 异常的邮件概率

select date, round(avg(if(type='no_completed',1,0)),3) as p from email as a where send_id in (select id from user where is_blacklist=0) ...

2025-04-14

0 37

题解 | 获取employees中的first_name

select first_name from ( select first_name,right(first_name,2) as right_name from employees order by right_name ) as a

2025-04-11

0 25

题解 | 将所有获取奖金的员工当前的薪水增加10%

update salaries set salary=salary*1.1 where emp_no in(select distinct b.emp_no from emp_bonus as b) and to_date='9999-01-01'

2025-04-11

0 36

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

select t1.emp_no, t2.emp_no as manager_no, t1.salary as emp_salary, t2.salary as manager_salary from ( select d1.emp_no,d1.dept_no,s.sa...

2025-04-06

0 39