牛客291451116号

分类

/ 注册

全部文章（共21篇）

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

select device_id,age,university from user_profile where university like '%北京%';

2025-05-08

0 8

题解 | 操作符混合运用

select device_id,gender,age,university,gpa from user_profile where (university in('山东大学') and gpa >3.5 ) or (university in('复旦大学') and gpa >3.8...

2025-05-08

0 8

题解 | Where in 和Not in

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

2025-05-08

0 10

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

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

2025-05-08

0 8

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

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

2025-05-08

0 9

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

select device_id,gender,age,university from user_profile where university not in('复旦大学');

2025-05-08

0 10

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

select device_id,gender,age from user_profile where age between 20 and 23;

2025-05-08

0 9

题解 | 查找年龄大于24岁的用户信息

select device_id,gender,age,university from user_profile where age > 24;

2025-05-08

0 9

题解 | 查找学校是北大的学生信息

select device_id , university from user_profile where university = '北京大学';

2025-05-08

0 13

题解 | 查找后降序排列

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

2025-05-08

0 8