小燕子my

分类

/ 注册

全部文章（共137篇）

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

SELECT COUNT(*),AVG(gpa) AS avg_gpa FROM user_profile WHERE gender='male' GROUP BY gender

2024-08-15

0 110

题解 | #查找GPA最高值#

SELECT MAX(gpa) FROM user_profile WHERE university='复旦大学'

2024-08-15

0 86

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

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

2024-08-15

0 91

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

SELECT device_id,gender,age,university,gpa FROM user_profile WHERE (gpa>3.5 AND university='山东大学') OR (gpa>3.8 AND university='复旦大学')

2024-08-15

0 101

题解 | #Where in 和Not in#

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

2024-08-15

0 94

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

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

2024-08-15

0 90

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

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

2024-08-15

0 102

题解 | #用where过滤空值练习#

SELECT device_id,gender,age,university FROM user_profile WHERE age IS NOT NULL

2024-08-15

0 110

题解 | #查找除复旦大学的用户信息#

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

2024-08-15

0 98

题解 | #查找某个年龄段的用户信息#

SELECT device_id,gender,age FROM user_profile WHERE age>=20 AND age<=23

2024-08-15

0 109