题解 | #查找山东大学或者性别为男生的信息#

#学校为山东大学或性别为男：university = '山东大学' or gender = '男'
#先输出山东大学：order by university
#拼接表：union all

with a as 
    (select device_id,gender,age,gpa from user_profile 
     where university = '山东大学'),
    b as 
    (select device_id,gender,age,gpa 
     from user_profile where gender = 'male')
select * from a union all select * from b