ForHeart

分类

/ 注册

TA的专栏 153篇文章 31人订阅

进阶高级测试工程师

142篇文章 1445人学习

AI自动测试化入门到精通

11篇文章 912人学习

全部文章（共156篇）

题解 | #二分查找-I#

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # # @param nums int整型一维数组 # @param target int整型 # @return int整型 # class Solution: def search(self , ...

2023-12-07

1 225

题解 | #各个视频的平均完播率#

select distinct t2.video_id, round(avg(if (timestampdiff(second,start_time,end_time) >= duration, 1, 0)) ,3)as avg_comp_play_rate from ...

2023-11-14

1 185

题解 | #将查询列重新命名#

select job_salary as '职位工资' from deliver_record

2023-11-14

1 191

题解 | #查询所有投递用户user_id并去重#

select distinct(user_id) from deliver_record order by user_id

2023-11-14

1 233

题解 | #21年8月份练题总数#

select count(distinct device_id) as did_cnt, count(question_id) as question_cnt from question_practice_detail where year(date) ='2021' and...

2023-11-14

0 197

题解 | #查找后降序排列#

select device_id, gpa, age from user_profile order by gpa desc, age desc

2023-11-14

1 184

题解 | #查找后多列排序#

select device_id, gpa, age from user_profile order by gpa asc, age asc

2023-11-14

0 207

题解 | #浙大不同难度题目的正确率#

select difficult_level, sum(if(result='right',1,0))/count(result) as correct_rate from user_profile u left join question_practice_deta...

2023-11-14

0 238

题解 | #截取出年龄#

select substring_index(substring_index(profile, ',', -2),',',1) as age, count(*) as number from user_submit group by age

2023-11-13

0 231

题解 | #提取博客URL中的用户名#

select device_id, substring_index (blog_url, '/', -1) as user_name from user_submit

2023-11-13

0 173