牛客532930148号
牛客532930148号
全部文章
分类
题解(20)
归档
标签
去牛客网
登录
/
注册
牛客532930148号的博客
全部文章
(共20篇)
题解 | #计算用户的平均次日留存率#
with s as ( select distinct device_id, date from question_practice_detail) select (select count(*) f...
Mysql
2022-05-14
0
240
题解 | #在audit表上创建外键约束,其emp_no对应employees_test表的主键id#
alter table audit add constraint audit_foreign_key_emp_no foreign key(emp_no) references employees_test...
Mysql
2022-05-13
0
266
题解 | #今天的刷题量(一)#
select subject.name, cnt from ( select subject_id, count(id) cnt from submission where create_time=...
Mysql
2022-05-13
0
251
题解 | #网易云音乐推荐(网易校招笔试真题)#
select music_name from music where id in (select music_id from music_likes where user_id&...
Mysql
2022-05-13
0
232
题解 | #商品交易(网易校招笔试真题)#
select s.goods_id, goods.name, goods.weight, total from (select goods_id, sum(count) total from trans&nbs...
Mysql
2022-05-13
0
289
题解 | #获得积分最多的人(三)#
with t as ( select distinct id, name, sum(grade_num*type)over(partition by id) g from (select&n...
Mysql
2022-05-13
0
248
题解 | #牛客的课程订单分析(七)#
select IFNULL(client.name,'GroupBuy') source, count(order_info.id) from order_info left join client on or...
Mysql
2022-05-12
0
229
题解 | #牛客的课程订单分析(六)#
select order_info.id, order_info.is_group_buy, client.name from order_info left join client on order_info...
Mysql
2022-05-12
0
261
题解 | #牛客每个人最近的登录日期(五)#
select date, round(IFNULL(sum(case when (user_id, date) in (select user_id, min(date) fr...
Mysql
2022-05-11
0
234
题解 | #牛客每个人最近的登录日期(六)#
select user.name, passing_number.date, sum(passing_number.number)over(partition by passing_number.user_id order by passing_number.date) from passing_n...
Mysql
2022-05-11
0
242
首页
上一页
1
2
下一页
末页