题解 | #查找山东大学或者性别为男生的信息#
查找山东大学或者性别为男生的信息
https://www.nowcoder.com/practice/979b1a5a16d44afaba5191b22152f64a
这种查询方式问题在哪
# SELECT distinct up.device_id,up.gender,up.age,up.gpa,up.university FROM user_profile up # LEFT JOIN question_practice_detail qd ON up.device_id= qd.device_id # WHERE up.university = "山东大学" OR up.gender = "male" # ORDER BY up.university desc,up.gender desc
