题解 | 操作符混合运用
操作符混合运用
https://www.nowcoder.com/practice/d5ac4c878b63477fa5e5dfcb427d9102
SELECT device_id,gender,age,university,gpa FROM user_profile WHERE gpa>3.5 AND university ='山东大学' UNION SELECT device_id,gender,age,university,gpa FROM user_profile WHERE gpa>3.8 AND university ='复旦大学' ORDER BY device_id;
