ForHeart

分类

/ 注册

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

进阶高级测试工程师

142篇文章 853人学习

AI自动测试化入门到精通

11篇文章 219人学习

全部文章（共152篇）

题解 | #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 172

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

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

2023-11-14

1 160

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

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

2023-11-14

0 175

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

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 198

题解 | #截取出年龄#

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

2023-11-13

0 188

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

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

2023-11-13

0 145

题解 | #计算用户8月每天的练题数量#

SELECT DAY (date) AS day, COUNT(*) AS question_cnt FROM question_practice_detail WHERE MONTH (date) = '08' group by day

2023-11-13

0 161

题解 | #查看不同年龄段的用户明细#

select device_id, gender, ( case when age >= 25 then '25岁及以上' when age >=20 and age <25 then '20-...

2023-11-13

0 189

题解 | #计算25岁以上和以下的用户数量#

select (case when age>=25 then '25岁及以上' else '25岁以下' end)as age_cut, count(*) as number from user_profile group by age_cut

2023-11-13

0 221

题解 | #买卖股票的最好时机(二)#

# # 代码中的类名、方法名、参数名已经指定，请勿修改，直接返回方法规定的值即可 # # 计算最大收益 # @param prices int整型一维数组股票每一天的价格 # @return int整型 # class Solution: def maxProfit(self , pric...

2023-11-10

0 167