JavaMaster_

分类

题解(19)

/ 注册

全部文章（共5篇）

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

select u.university, qd.difficult_level, count(q.question_id) / count(distinct q.device_id) as avg_answer_cnt from user_profile as ...

Mysql

2022-05-21

0 343

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

select u.university, qd.difficult_level, count(q.question_id) / count(distinct q.device_id) as avg_answer_cnt from user_profile as u...

Mysql

2022-05-21

0 353

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

select university, count(question_practice_detail.question_id) / count(distinct question_practice_detail.device_id) as avg_answer_cnt from qu...

Mysql

2022-05-20

0 378

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

select question_practice_detail.device_id, question_practice_detail.question_id, question_practice_detail.result from question_practice_d...

Mysql

2022-05-20

0 335

题解 | #计算男生人数以及平均GPA#

select count(gender) as male_num, sum(gpa) / count(gpa) as avg_gpa from user_profile where gender = "male"

Mysql

2022-05-19

0 387