牛客207221769号

分类

题解(2)

/ 注册

全部文章（共57篇）

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

select name,sum(grade_num) grade_num from grade_info left join user on user.id = grade_info.user_id group by name order by grade_num desc limit 1 offs...

2024-02-05

0 193

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

select grade ,(select sum(number) from class_grade t2 where t1.grade>=t2.grade) from class_grade t1 order by grade 子查询

2024-02-05

0 173

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

select grade,sum(number) over(order by grade) t_rank from class_grade

2024-02-05

0 140

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

select job,date_format(date,"%Y-%m") mon,sum(num) cnt from resume_info where year(date) = 2025 group by job,mon order by mon desc,cnt desc

2024-02-05

0 236

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

SELECT t1.id id,is_group_buy,name client_name FROM ( SELECT *,count(1) over(partition by user_id) number from order_info where datediff(date,&...

2024-02-05

0 154

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

SELECT order_info.id id,is_group_buy,name client_name FROM order_info left join client on order_info.client_id = client.id WHERE user_id in( SELEC...

2024-02-05

0 177

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

select distinct user_id from order_info a where exists( select count(1) cnt from order_info b where product_name in ("C++",&qu...

2024-02-05

0 147

题解 | #考试分数(二)#

select * from grade a where exists( select avg(score) avg from grade b where a.job = b.job group by job having a.score> avg ) order by id

2024-02-04

0 189

题解 | #平均工资#

select avg(salary) from salaries where to_date='9999-01-01' and salary not in ( select max(salary) from salaries where to_date='9999-01-01' u...

2024-02-04

0 210

题解 | #创建一个actor表，包含如下列信息#

create table `actor`( `actor_id` smallint(5) primary key, `first_name` varchar(45) not null, `last_name` varchar(45) not null, `last_u...

2024-02-04

0 205