爆栈炸死各位爷
爆栈炸死各位爷
全部文章
分类
归档
标签
去牛客网
登录
/
注册
爆栈炸死各位爷的博客
全部文章
(共46篇)
题解 | #统计不同类型题目的刷题数,并按刷题数进行升序排列
select question_type,sum(pass_count) passCnt from questions_pass_record_detail group by question_type order by passCnt
2023-11-10
0
64
题解 | #统计每天刷题数超过5的user_id以及刷题数#
select date,user_id,sum(pass_count) total_pass_count from questions_pass_record_detail group by user_id,date having sum(pass_count) > 5
2023-11-10
0
110
题解 | #统计每天总刷题数#
select date days, sum(pass_count) 'passCnt' from questions_pass_record_detail group by date
2023-11-10
0
62
题解 | #计算单次平均刷题数#
select avg(pass_count) avgCnt from questions_pass_record_detail
2023-11-10
0
62
题解 | #找出sql类题目的单次最大刷题数#
select max(pass_count) from questions_pass_record_detail where question_type = 'sql' group by question_type
2023-11-10
0
74
题解 | #计算刷题总人数#
select count(distinct user_id) cnt from questions_pass_record_detail
2023-11-10
0
56
题解 | #计算总刷题数,并将所选列名改为总刷题数#
select sum(pass_count) '总刷题数' from questions_pass_record_detail
2023-11-10
0
61
题解 | #查询城市为北京的职位投递记录#
select * from deliver_record_detail where job_city like '北京%'
2023-11-10
0
59
题解 | #查询薪资信息不为空的职位投递记录#
select * from deliver_record_detail where min_salary is not null or max_salary is not null
2023-11-10
0
167
题解 | #查询投递最低最高薪资差别大于2的职位的投递用户
select user_id from deliver_record_detail where max_salary - min_salary > 2
2023-11-10
0
71
首页
上一页
1
2
3
4
5
下一页
末页