XiaoBY

分类

/ 注册

全部文章（共41篇）

题解 | 最差是第几名(一)

#解法1 select grade, sum(number) over ( order by grade ) from class_grade order by grade #解法2 select grad...

2024-12-19

0 51

题解 | 游游的数字圈

import sys def main(): str1 = input() sum = 0 for i in range(len(str1)): if str1[i] == '0' or str1[i] == '6' or str1[i] == '9': ...

2024-12-16

0 40

题解 | 小美的因子查询

import sys def main(): T = int(input()) for i in range(T): a = int(input()) if a % 2 == 0 and a > 2: print(&qu...

2024-12-16

0 38

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

select job, concat (year (date), '-', LPAD(MONTH(date), 2, '0')) as mon, sum(num) as cnt from resume_info where year(date) = 2025 grou...

2024-12-16

0 37

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

select oi.id, is_group_buy, if(is_group_buy = 'NO',name, 'None') as client_name from order_info oi left join client c on oi.client...

2024-12-16

0 43

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

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

2024-12-16

0 47

题解 | 平均工资

select avg(salary) from salaries where to_date = '9999-01-01' and ( salary <> ( select max(s...

2024-12-15

0 51

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

select last_name, first_name, dept_name from dept_emp left join departments on dept_emp.dept_no = departments.dept_no right jo...

2024-12-11

0 45

题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#

select title, avg(salary) as sal from titles inner join salaries on titles.emp_no = salaries.emp_no group by title order by sal asc

2024-12-11

0 48

题解 | #获取所有非manager的员工emp_no#

select employees.emp_no from employees left join dept_manager on employees.emp_no = dept_manager.emp_no where dept_manager.dept_no is null

2024-12-09

0 37