GuaMiao

分类

/ 注册

全部文章（共92篇）

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

select university, round(question_count/student_count, 4) as avg_answer_cnt from ( select count(distinct a.device_id) as student_count, count(a.q...

2023-07-31

1 280

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

select device_id, question_id, result from question_practice_detail where device_id in ( select device_id from user_profile where universi...

2023-07-30

1 224