牛客532930148号

题解

/ 注册

全部文章 / 题解（共20篇）

题解 | #计算用户的平均次日留存率#

with s as ( select distinct device_id, date from question_practice_detail) select (select count(*) f...

Mysql

2022-05-14

0 175

题解 | #在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 164

题解 | #今天的刷题量(一)#

select subject.name, cnt from ( select subject_id, count(id) cnt from submission where create_time=...

Mysql

2022-05-13

0 168

题解 | #网易云音乐推荐(网易校招笔试真题)#

select music_name from music where id in (select music_id from music_likes where user_id&...

Mysql

2022-05-13

0 163

题解 | #商品交易(网易校招笔试真题)#

select s.goods_id, goods.name, goods.weight, total from (select goods_id, sum(count) total from trans&nbs...

Mysql

2022-05-13

0 194

题解 | #获得积分最多的人(三)#

with t as ( select distinct id, name, sum(grade_num*type)over(partition by id) g from (select&n...

Mysql

2022-05-13

0 172

题解 | #牛客的课程订单分析(七)#

select IFNULL(client.name,'GroupBuy') source, count(order_info.id) from order_info left join client on or...

Mysql

2022-05-12

0 147

题解 | #牛客的课程订单分析(六)#

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 190

题解 | #牛客每个人最近的登录日期(五)#

select date, round(IFNULL(sum(case when (user_id, date) in (select user_id, min(date) fr...

Mysql

2022-05-11

0 157

题解 | #牛客每个人最近的登录日期(六)#

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 165