羌昼晦

分类

/ 注册

TA的专栏 149篇文章 34人订阅

TOP101-BM系列

64篇文章 556人学习

42篇文章 997人学习

SQL专项练习

43篇文章 818人学习

全部文章（共149篇）

SQL18题解 | #分组计算练习题# 来自专栏

SELECT gender, university, count(device_id) AS user_num, round(avg(active_days_within_30), 1) AS avg_acti...

2023-09-14

0 423

SQL17题解 | #计算男生人数以及平均GPA# 来自专栏

SELECT count(gender) AS male_num, round(avg(gpa),1) AS avg_gpa FROM user_profile WHERE gender = 'male';

2023-09-14

0 652

SQL16题解 | #查找GPA最高值# 来自专栏

SELECT round(max(gpa), 1) as gpa #保留一位小数 FROM user_profile WHERE university = '复旦大学';

2023-09-14

4 435

SQL15题解 | #查看学校名称中含北京的用户# 来自专栏

SELECT device_id, age, university FROM user_profile WHERE university like '%北京%';

2023-09-14

0 395

SQL14题解 | #操作符混合运用# 来自专栏

SELECT device_id, gender, age, university, gpa FROM user_profile WHERE (gpa > 3.5 and university = '山东大学') or (gpa > 3.8 and univers...

2023-09-14

0 253

SQL13题解 | #Where in 和Not in# 来自专栏

SELECT device_id, gender, age, university, gpa FROM user_profile WHERE university in ('北京大学','复旦大学','山东大学');

2023-09-14

0 468

SQL12题解 | #高级操作符练习(2）# 来自专栏

SELECT device_id, gender, age, university, gpa FROM user_profile WHERE university = '北京大学' or gpa > 3.7;

2023-09-14

0 261

SQL11题解 | #高级操作符练习(1)# 来自专栏

SELECT device_id, gender, age, university, gpa FROM user_profile WHERE gender = 'male' and gpa > 3.5;

2023-09-14

1 646

SQL10题解 | #用where过滤空值练习# 来自专栏

SELECT device_id, gender, age, university FROM user_profile WHERE age != 'NULL';

2023-09-14

0 381

SQL9题解 | #查找除复旦大学的用户信息# 来自专栏

SELECT device_id, gender, age, university FROM user_profile WHERE university != '复旦大学';

2023-09-14

0 244