牛客283607898号

分类

/ 注册

全部文章（共13篇）

题解 | 某宝店铺连续2天及以上购物的用户及其对应的天数

with t as ( select distinct sales_date,user_id, dense_rank() over(partition by user_id order by sales_date) as rk from sales_tb ) ...

2025-03-04

0 27

题解 | 牛客直播各科目平均观看时长

# select course_name, # round(avg(timestampdiff(minute,if(in_datetime<=substring(course_datetime,1,15),course_datetime,in_datetime),out_dat...

2025-02-21

0 48

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

with t as ( select a.device_id,university,b.question_id,result,difficult_level from user_profile a join question_practice_detail b on a.d...

2025-02-20

0 62

题解 | 统计复旦用户8月练题情况

with t as ( select a.device_id,university,question_id,date,result from user_profile a join question_practice_detail b on a.device_id = b.devic...

2025-02-20

0 51

题解 | 最长连续登录天数

select user_id, max(days) as max_consec_days from( select user_id, datediff(max(fdate),min(fdate))+1 as days from ( select user_id...

2025-02-19

3 157

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

select q.device_id, q.question_id, q.result from question_practice_detail q left join user_profile u on q.device_id = u.device_id where university =...

2024-09-09

0 78

题解 | #分组排序练习题#

select university,avg(question_cnt) as avg_question_cnt from user_profile group by university order by avg(question_cnt)

2024-09-09

0 80

题解 | #分组过滤练习题#

select university, round(avg(question_cnt),3) as avg_question_cnt, round(avg(answer_cnt),3) as avg_answer_cnt from user_profile group by university ha...

2024-09-09

0 71

题解 | #分组计算练习题#

select gender, university, count(gender) user_num, round(avg(active_days_within_30),1) avg_active_day, round(avg(question_cnt),1) avg_question_c...

2024-09-09

0 72

题解 | #查找GPA最高值#

select max(gpa) gpa from user_profile where university = '复旦大学'

2024-09-09

0 68