爆栈炸死各位爷
爆栈炸死各位爷
全部文章
分类
归档
标签
去牛客网
登录
/
注册
爆栈炸死各位爷的博客
全部文章
(共46篇)
题解 | #输出提交次数大于2次的用户ID且倒序排列#
select user_id from done_questions_record group by user_id having count(*) >2 order by user_id desc
2023-11-11
0
74
题解 | #分群并计算群体人数#
select CASE WHEN age<20 THEN '20以下' WHEN age<50 THEN '20-50' WHEN age>50 THEN '50以上' ELSE '未填写' END A...
2023-11-11
0
67
题解 |
select * from customers_info order by city,country
2023-11-11
0
80
题解 | #判断其是否有过购买记录#
select customer_id,if(latest_place_order_date is not null,1,0) if_placed_order from customers_info
2023-11-11
0
104
题解
SELECT job_id, boss_id, company_id FROM ( SELECT job_id, boss_id, company_id, job_city FROM job_info WHERE post_time > '2021-01-01 00:00:00' ...
2023-11-11
0
68
题解 |
select job_id,company_id from job_info where job_city = '北京' UNION ALL select job_id,company_id from job_info where salary > 100000
2023-11-11
0
133
题解 | #查询每个公司查看过的投递用户数#
select ji.company_id,sum(dr.resume_if_checked) cnt from job_info ji left join deliver_record dr on ji.job_id = dr.job_id group by ji.company_id having...
2023-11-11
0
113
题解 | #查询被投递过的职位信息#
select ji.job_id,ji.boss_id,ji.company_id,ji.post_time,ji.salary,ji.job_city from job_info ji left join deliver_record dr on ji.job_id = dr.job_id gr...
2023-11-11
0
85
查询2022年以来刷题用户的用user_id和毕业院校
select user_id, university from user_info where EXISTS ( select user_id from questions_pass_re...
2023-11-11
0
97
题解 | #查询2022年毕业用户的刷题记录#
select ui.user_id,qpr.question_type,qpr.device,qpr.pass_count,qpr.date from user_info ui inner join questions_pass_record qpr on ui.user_i...
2023-11-11
0
67
首页
上一页
1
2
3
4
5
下一页
末页