阿莉勒丝黛拉

分类

题解(169)

/ 注册

全部文章（共128篇）

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

SELECT university, AVG(question_cnt) avg_question_cnt FROM user_profile G...

Mysql

2022-03-02

1 369

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

SELECT university, AVG(question_cnt) avg_question_cnt, AVG(answer_cnt)&nb...

Mysql

2022-03-02

1 309

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

SELECT gender, university, COUNT(*) user_num, AVG(active_days_within_30) avg_active_day, ...

Mysql

2022-03-01

1 310

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

SELECT count(gender) male_num, avg(gpa) avg_gpa from user_profile WH...

Mysql

2022-03-01

4 635

题解 | #查找GPA最高值#

select max(gpa) from user_profile WHERE university = '复旦大学' ;

Mysql

2022-03-01

1 351

题解 | #查看学校名称中含北京的用户#

SELECT device_id, age, university FROM use...

Mysql

2022-03-01

3 633

题解 | #操作符混合运用#

select device_id, gender, age, unive...

Mysql

2022-03-01

1 346

题解 | #Where in 和Not in#

SELECT device_id, gender, age, unive...

Mysql

2022-03-01

4 437

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

SELECT device_id, gender, age, unive...

Mysql

2022-03-01

2 1460

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

SELECT device_id, gender, age, unive...

Mysql

2022-03-01

9 2626