那星阿伦

分类

/ 注册

全部文章（共15篇）

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

select university, difficult_level, count(qpd.question_id)/count(distinct qpd.device_id) as avg_answer_cnt from question_pract...

2024-11-21

0 31

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

select university, count(question_id)/count(distinct t1.device_id) as avg_answer_cnt from user_profile t1 join question_practice_detai...

2024-11-21

0 38

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

# select device_id,question_id,result # from question_practice_detail # where device_id in # (select device_id from user_profile where university = '...

2024-11-20

0 48

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

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-11-19

0 47

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

select gender, university, count(device_id) as user_num, avg(active_days_within_30) as avg_active_day, avg(question_cnt) as avg_quest...

2024-11-19

90 48