牛客106702533号

分类

题解(50)

/ 注册

全部文章（共35篇）

题解 | #插入记录（二）#

insert into exam_record_before_2021(uid,exam_id,start_time,submit_time,score) select uid,exam_id,start_time,submit_time,score from exam_record where s...

Mysql

2022-02-21

0 284

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

select u.name u_n,c.name c_n,t.maxdate date from (select user_id,max(date) maxdate from login group by user_id) t join (select user_id,client...

Mysql

2021-10-06

0 395

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

select g.* from grade g join (select job,avg(score) avgs from grade group by job) t on g.job = t.job where g.score > t.avgs order by g.id

Mysql

2021-10-06

0 334

题解 | #商品交易(网易校招笔试真题)#

select g.id,g.name,g.weight,t.total from goods g join (select goods_id,sum(count) total from trans group by goods_id) t on g.id = t.goods_id where t...

Mysql

2021-10-05

0 318

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

select u.id,u.name,t.grade_num from user u join (select user_id,sum(grade_num) grade_num from grade_info group by user_id) t on u.id = t.user_id joi...

Mysql

2021-10-05

0 285

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

select u.name,t.grade_num from user u join (select user_id,sum(grade_num) grade_num from grade_info group by user_id ) t on u.id = t.user_id order b...

Mysql

2021-10-05

0 364

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

select t.job,t.mon first_year_mon,t.cnt first_year_cnt,n.mon second_year_mon,n.cnt second_year_cnt from (select job,DATE_FORMAT(date,'%Y-%m') mon,sum(...

Mysql

2021-10-05

0 362

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

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

Mysql

2021-10-05

0 288

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

select job,sum(num) cnt from resume_info where year(date) = '2025' group by job ORDER BY cnt DESC

Mysql

2021-10-05

0 253

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

select o.user_id,min(o.date) first_buy_date,count(o.product_name) cnt from order_info o join (select distinct user_id from order_info w...

Mysql

2021-10-05

0 301