ForHeart

分类

/ 注册

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

进阶高级测试工程师

142篇文章 853人学习

AI自动测试化入门到精通

11篇文章 219人学习

全部文章（共152篇）

题解 | 浙江大学用户题目回答情况

select device_id, question_id, result from question_practice_detail pd where pd.device_id = ( select up.device...

2025-02-13

0 34

题解 | 分组排序练习题

select up.university, AVG(up.question_cnt) as avg_question_cnt from user_profile up group by up.university order by avg_question_cnt a...

2025-02-13

0 37

题解 | 分组过滤练习题

select university, avg_question_cnt, avg_answer_cnt from ( select up.university, AVG(up.question_cnt) ...

2025-02-13

0 37

题解 | 分组计算练习题

select up.gender, up.university, count(1) as user_num, AVG(up.active_days_within_30) as avg_active_day, AVG(up.question_cnt) as av...

2025-02-13

0 33

题解 | #列表动态渲染#

{"html":"<!DOCTYPE html>\r\n<html lang=\"en\">\r\n <head>\r\n <meta charset=\"UTF-8\"...

2024-03-28

0 163

题解 | #二维数组中的查找#

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

2023-12-07

1 210

题解 | #二分查找-I#

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

2023-12-07

1 197

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

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 147

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

select job_salary as '职位工资' from deliver_record

2023-11-14

1 160

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

select distinct(user_id) from deliver_record order by user_id

2023-11-14

1 183