高级资深攻城狮
高级资深攻城狮
全部文章
题解
归档
标签
去牛客网
登录
/
注册
高级资深攻城狮的博客
全部文章
/ 题解
(共51篇)
题解 | #分组过滤练习题#
select replace(SUBSTRING(start_time,1,7),"-",""), round(count(distinct uid, date_format(submit_time, '%Y%m%d')) / count(distinct uid),2), count(distin...
Mysql
2021-11-17
0
225
题解 | #分组过滤练习题#
select device_id,up1.university,up1.gpa from user_profile as up1,(select university,min(gpa)as gpa from user_profile group by university)as up2 where ...
Mysql
2021-10-20
0
206
题解 | #分组过滤练习题#
select device_id,up1.university,up1.gpa from user_profile as up1,(select university,min(gpa)as gpa from user_profile group by university)as up2 where ...
Mysql
2021-10-20
0
219
题解 | #分组过滤练习题#
select university,difficult_level,count(up.device_id)/ count(distinct(up.device_id)) from user_profile as up,question_practice_detail as qpd,question_...
Mysql
2021-10-18
0
192
题解 | #分组过滤练习题#
select university,count(question_id)/ count(distinct up.device_id) as avga from user_profile as up,question_practice_detail as qpd where up.device_id ...
Mysql
2021-10-15
0
190
题解 | #分组过滤练习题#
select qpd.device_id,question_id,result from question_practice_detail as qpd,user_profile as up where qpd.device_id=up.device_id and university="浙江大学"
Mysql
2021-10-15
0
228
题解 | #获得积分最多的人(二)#
select distinct music_name from follow as f,music_likes as ml,music as m where f.user_id='1' and f.follower_id=ml.user_id and ml.music_id=m.id and ml....
Mysql
2021-10-15
0
254
题解 | #获得积分最多的人(二)#
select user_id,name,sum from ( select user_id,name,sum(if(type='reduce',-1grade_num,grade_num))as sum, (select sum(if(type='reduce',-1grade_num,grade_...
Mysql
2021-10-15
0
194
题解 | #获得积分最多的人(二)#
select user_id,name,s from (select user_id,name,sum(grade_num) as s,m from grade_info as gi,user as u,(select sum(grade_num)as m from grade_info group...
Mysql
2021-10-15
0
214
题解 | #牛客的课程订单分析(三)#
select grade from class_grade a4 , ( select * from (select grade as g1 from (select sum(number)as sum,round(sum(number)/2) as s,if(sum(number)%2=0,rou...
Mysql
2021-10-15
0
253
首页
上一页
1
2
3
4
5
6
下一页
末页