NiCaprio

分类

/ 注册

全部文章（共12篇）

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

select university, count(question_id) / count(distinct qpd.device_id) as avg_answer_cnt from question_practice_detail as qpd inner join user_p...

2023-08-19

0 183

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

select qpd.device_id, qpd.question_id, qpd.result from question_practice_detail as qpd inner join user_profile as up on up.device_id=qpd.device_id and...

2023-08-19

0 235

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

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

2023-08-02

0 201

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

select gender, university, count(device_id) as user_num, avg(active_days_within_30) as avg_active_days, avg(question_cnt) as avg_ques...

2023-08-02

0 159

题解 | #查找GPA最高值#

select max(gpa) as gpa from user_profile where university = "复旦大学"; select gpa from user_profile where university = "复旦大学" orde...

2023-08-02

0 167

题解 | #Where in 和Not in#

select device_id, gender, age, university, gpa from user_profile where university in ("北京大学", "复旦大学", "山东大学");

2023-08-02

0 161

题解 | #高级操作符练习(2）#

select device_id, gender, age, university, gpa from user_profile where university = "北京大学" or gpa > 3.7;

2023-08-02

0 176

题解 | #高级操作符练习(1)#

select device_id, gender, age, university, gpa from user_profile where gpa > 3.5 and gender = "male";

2023-08-02

0 217

题解 | #查找后降序排列#

select device_id, gpa, age from user_profile order by gpa desc, age desc;

2023-08-02

0 193

题解 | #查找后多列排序#

select device_id, gpa, age from user_profile order by gpa asc, age asc;

2023-08-02

0 193