牛客797465787号
牛客797465787号
全部文章
分类
题解(48)
归档
标签
去牛客网
登录
/
注册
牛客797465787号的博客
全部文章
(共30篇)
题解 | #删除记录(二)#
delete from exam_record where submit_time is null &nbs***bsp; timestampdiff(minute,start_time,submit_time)<5 ...
Mysql
2022-06-24
0
129
题解 | #更新记录(二)#
update exam_record set submit_time='2099-01-01 00:00:00',score=0 where start_time <'2021-09-01 00:00:00' and submit_time is null;
Mysql
2022-06-24
0
151
题解 | #插入记录(二)#
INSERT INTO exam_record_before_2021 SELECT null,uid,exam_id,start_time,submit_time,score FROM exam_record WHERE year(submit_...
Mysql
2022-06-23
0
182
题解 | #插入记录(一)#
insert into exam_record (uid,exam_id,start_time,submit_time,score) values(1001,9001,'2021-09-01 22:11:12','2021-09-01 23:01:12',90),(1002, 9002,...
Mysql
2022-06-23
0
153
题解 | #浙大不同难度题目的正确率#
select difficult_level, sum(if(result='right',1,0))/ count(q.question_id) correct_rate from user_profile u inner join question_pract...
Mysql
2022-06-22
0
206
题解 | #统计复旦用户8月练题情况#
select u.device_id,university, count(question_id) question_cnt ,sum(case when result='right' then 1 else 0 end ) right_question_cnt from user_pr...
Mysql
2022-06-22
0
189
题解 | #操作符混合运用#
select device_id,gender,age,university,gpa from user_profile where (gpa>3.5 and university='山东大学') or (gpa>3.8 and university=...
Mysql
2022-06-22
0
166
题解 | #分组过滤练习题#
select university , avg(question_cnt) avg_question_cnt ,avg(answer_cnt) avg_answer_cnt from user_profile u group by univ...
Mysql
2022-06-22
0
148
题解 | #分组计算练习题#
select gender, university , count(device_id) user_num ,avg(active_days_within_30) avg_active_day ,avg(question_cnt) avg_question_cnt from ...
Mysql
2022-06-22
0
176
题解 | #查找山东大学或者性别为男生的信息#
select device_id,gender,age,gpa from user_profile u where university='山东大学' union all select device_id,gender,age,gpa from user_profile u where ...
Mysql
2022-06-22
0
135
首页
上一页
1
2
3
下一页
末页