题解 | #查询职位发布时间在2021年后或职位城市为...

select
    job_id,
    boss_id,
    company_id
from
(select
    job_id,
    boss_id,
    company_id,
    job_city
from
    job_info
where
    YEAR (post_time) >= 2021
union
select
    job_id,
    boss_id,
    company_id,
    job_city
from
    job_info
where
    job_city like '上海%'
) t
order by job_city

“t”：起个别名 —— 建议习惯性使用别名，否则会报错