阿莉勒丝黛拉

分类

题解(169)

/ 注册

全部文章（共162篇）

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

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

Mysql

2022-03-02

1 361

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

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

Mysql

2022-03-02

1 299

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

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

Mysql

2022-03-01

1 301

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

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

Mysql

2022-03-01

4 623

题解 | #查找GPA最高值#

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

Mysql

2022-03-01

1 343

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

SELECT device_id, age, university FROM use...

Mysql

2022-03-01

3 623

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

select device_id, gender, age, unive...

Mysql

2022-03-01

1 333

题解 | #Where in 和Not in#

SELECT device_id, gender, age, unive...

Mysql

2022-03-01

4 426

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

SELECT device_id, gender, age, unive...

Mysql

2022-03-01

2 1446

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

SELECT device_id, gender, age, unive...

Mysql

2022-03-01

9 2613