牛客815698333号

题解

/ 注册

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

题解 | #二分查找-I#

import java.util.*; public class Solution { /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * * @param nums int整型一维数组 * @param target int整型 * @return int...

Java

2022-03-16

0 301

题解 | #二分查找-I#

import java.util.*; public class Solution { /** * 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 * * * @param nums int整型一维数组 * @param target int整型 * @return int...

Java

2022-03-16

0 344

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

with u1 as (select distinct device_id,date from question_practice_detail) select (count(u2.device_id))/(count(u1.device_id)) from u1 left join u1 as ...

Mysql

2021-12-16

0 290

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

with t as (select ,sum((grade_num)(if(type='add',1,-1))) as grade_sum from grade_infogroup by user_id)select id,name,grade_sumfrom t,userwhere id=user...

2021-04-26

0 512

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

with t as (select distinct id,name,sum(grade_num) over(partition by user_id) grade_sumfrom userjoin grade_infoon id=user_id)select * from twhere grade...

2021-04-25

0 399

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

select * from (select name,sum(grade_num) grade_sum from userjoin grade_info on id=user_idwhere type='add'group by user_id) torder by grade_sum descli...

2021-04-23

0 435

题解 | #实习广场投递简历分析(三)#

感觉我写的太麻烦了，我去偷个师select t1.job ,first_year_mon,first_year_cnt,second_year_mon,second_year_cntfrom (select job,date_format(date,'%Y-%m') first_year_mon,s...

2021-04-23

0 544

题解 | #实习广场投递简历分析(二)#

select job,left(date,7) mon,sum(num) cntfrom resume_infowhere year(date)='2025'group by job,month(date)order by mon desc,cnt desc;

2021-04-23

0 555

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

with t as(select * from order_info where date>'2025-10-15' and status='completed' and product_name in ('C++','Java','Python'))select ifnull(name,'G...

2021-04-19

0 540

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

with t as (select * from order_infowhere date>'2025-10-15' and status='completed' and product_name in('Python','Java','C++'))select t1.id,is_group...

2021-04-16

0 457