牛客291451116号

分类

/ 注册

全部文章（共22篇）

题解 | 浙江大学用户题目回答情况

select question_practice_detail.device_id, question_id, result from question_practice_detail inner join user_profile on question_p...

2025-05-09

0 32

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

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

2025-05-08

0 26

题解 | 操作符混合运用

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 25

题解 | Where in 和Not in

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

2025-05-08

0 26

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

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

2025-05-08

0 19

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

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

2025-05-08

0 26

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

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

2025-05-08

0 28

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

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

2025-05-08

0 26

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

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

2025-05-08

0 21

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

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

2025-05-08

0 31