Owen433

分类

/ 注册

全部文章（共65篇）

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

select t1.device_id, t1.university, sum( case when t2.id is not null then 1 else 0 end ) question_c...

2023-09-25

0 255

题解 | #找出每个学校GPA最低的同学#

select distinct t1.device_id, t1.university, t1.gpa from user_profile t1 where (t1.university,t1.gpa) in (select university,...

2023-09-25

0 216

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

select day(t1.date) day, count(*) question_cnt from question_practice_detail t1 where t1.date >= '2021-08-01' and t1.date ...

2023-09-25

0 153

题解 | #统计每个用户的平均刷题数#

select t1.university, t3.difficult_level, round(count(t1.answer_cnt)/count(distinct t1.answer_cnt),4) avg_answer_cnt from user_profile...

2023-09-25

0 219

题解 | #统计每个学校各难度的用户平均刷题数#

select t1.university, t3.difficult_level, round(count(t1.answer_cnt)/count(distinct t1.answer_cnt),4) avg_answer_cnt from user_profile...

2023-09-25

0 218

题解 | #统计每个学校的答过题的用户的平均答题数#

select t2.university, round(sum(answer_cnt)/count(*),4) avg_answer_cnt from user_profile t2 left join (select question_pract...

2023-09-25

0 261

题解 | #班级管理#

class Student(): def __init__(self): self.name = '' self.ID = '' self.score = '' self.classes = '' self.co...

2023-09-21

0 249

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

SELECT t1.user_id, t2.name, t1.grade_num FROM (SELECT user_id, SUM(CASE WHEN type = 'add' THEN grade_...

2023-09-21

0 228

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

select t2025.job, t2025.first_year_mon, t2025.first_year_cnt, t2026.second_year_mon, t2026.second_year_cnt from (select ...

2023-09-21

0 171

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

select t1.user_id, t1.date first_buy_date, t2.date second_buy_date, t3.cnt from (select user_id, min(date) date ...

2023-09-20

0 266