高级资深攻城狮
高级资深攻城狮
全部文章
分类
题解(90)
归档
标签
去牛客网
登录
/
注册
高级资深攻城狮的博客
全部文章
(共82篇)
题解 | #牛客的课程订单分析(三)#
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
239
题解 | #牛客的课程订单分析(三)#
select job,substring(date,1,7)as mon,sum(num) as num from resume_info where substring(date,1,4)='2025' group by job,substring(date,1,7) order by mon d...
Mysql
2021-10-09
0
215
题解 | #牛客的课程订单分析(三)#
有思路就能写出来, select if(o.is_group_buy='Yes','GroupBuy',c.name)as source,count(o.client_id) from order_info as o left join client as c on o.client_id=c.id...
Mysql
2021-10-09
0
261
题解 | #牛客的课程订单分析(三)#
select o.id,o.is_group_buy,if(is_group_buy='Yes',null,c.name) from order_info as o left join client as c on o.client_id=c.id where o.status='completed...
Mysql
2021-10-09
0
239
题解 | #牛客的课程订单分析(三)#
select d.user_id as id,d.date as d1,c.date as d2,d.count as count from ( select a.user_id as user_id,min(b.date) as date,a.count from ( select user_id...
Mysql
2021-10-08
0
269
题解 | #牛客的课程订单分析(三)#
select user_id,min(date),count(user_id) from order_info where product_name in ('Java','C++','Python') and date > '2025-10-15' and status='completed...
Mysql
2021-10-08
0
168
题解 | #牛客的课程订单分析(三)#
select * from order_info where product_name in('C++','Java','Python') and user_id in(select user_id from order_info where product_name in('Java','C++'...
Mysql
2021-10-08
0
182
题解 | #考试分数(二)#
select user_id from order_info where product_name in('C++','Java','Python') and date > '2025-10-15' and status = 'completed' group by user_id havin...
Mysql
2021-10-08
0
229
题解 | #考试分数(二)#
select * from order_info where date >='2025-10-15' and product_name in('Java','C++','Python') and status='completed' order by 'id' asc
Mysql
2021-10-08
0
198
题解 | #考试分数(二)#
运行通过,解题思路如下:先筛选出最大的score记录和language_id信息,然后将最大记录排除,筛选出剩下记录中的最大记录(第二高的score)。 这样的话会遇到一种情况,如果只有一条记录的话,第二条记录是筛选不出来的。 所以在每次筛选出来后要做一次汇总,更新最大记录,如果筛选出记录,就将之前...
Mysql
2021-09-30
0
295
首页
上一页
1
2
3
4
5
6
7
8
9
下一页
末页