XiaoBY

分类

/ 注册

全部文章（共41篇）

题解 | 字符串分隔

import sys s = input() while len(s) > 8: print(s[:8]) s = s[8:] if len(s) < 8: s += "0" * (8 - len(s)) print(s)

2025-06-02

0 23

题解 | 获取有奖金的员工相关信息。

select e.emp_no, first_name, last_name, btype, salary, ( case btype when 1 then round(0.1*salary,1) ...

2024-12-22

0 76

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

select de.dept_no, de.emp_no, s.salary from dept_emp de inner join employees e on de.emp_no = e.emp_no inner join dept_manager...

2024-12-22

0 35

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

select emp_no, salary, dense_rank() over(order by salary desc) as t_rank from salaries order by t_rank asc, emp_no asc

2024-12-22

0 48

题解 | 实习广场投递简历分析(一)

select job, sum(num) as cnt from resume_info where date >= '2025-01-01' and date <= '2025-12-31' group by job order by cnt d...

2024-12-21

0 38

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

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

2024-12-21

0 45

题解 | 考试分数(一)

select job, round(avg(score),3) as avg from grade group by job order by avg desc

2024-12-21

0 43

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

select user_id, max(date) as id from login group by user_id order by user_id asc

2024-12-21

0 58

题解 | 批量插入数据

insert into actor values(1, 'PENELOPE', 'GUINESS', '2006-02-15 12:34:33'),(2, 'NICK', 'WAHLBERG', '2006-02-15 12:34:33')

2024-12-21

0 51

题解 | 获得积分最多的人(一)

select name, sum(grade_num) over ( partition by user_id order by user_id ) as grade_num from g...

2024-12-19

0 51