题解 | 操作符混合运用
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
select
device_id,
gender,
age,
university,
gpa
from
user_profile
where
(gpa > 3.5 and university = '山东大学')
or
(gpa > 3.8 and university = '复旦大学')
order by device_id
-- asc 升序 不加默认升序
-- desc 降序
and优先级高于or；为了严谨加（）；order by 按照device_id 排序
SQL刷题 文章被收录于专栏
SQL刷题文章专栏
