题解 | 操作符混合运用
操作符混合运用
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`