XiaoBY

分类

/ 注册

全部文章（共48篇）

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

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

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 69

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

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

2024-12-21

0 68

题解 | 考试分数(一)

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

2024-12-21

0 74

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

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

2024-12-21

0 78

题解 | 批量插入数据

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 80

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

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

2024-12-19

0 80

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

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

2024-12-19

0 75

题解 | 游游的数字圈

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 66

题解 | 小美的因子查询

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 60