题解 | #查找山东大学或者性别为男生的信息#
SELECT
device_id,
gender,
age,
gpa
FROM
user_profile
WHERE
university = '山东大学'
UNION ALL
SELECT
device_id,
gender,
age,
gpa
FROM
user_profile
WHERE
gender = 'male'
SELECT
device_id,
gender,
age,
gpa
FROM
user_profile
WHERE
university = '山东大学'
UNION ALL
SELECT
device_id,
gender,
age,
gpa
FROM
user_profile
WHERE
gender = 'male'
相关推荐
查看15道真题和解析