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

select
    tmp.job_id,
    tmp.boss_id,
    tmp.company_id
from
    (select
        a.job_id,
        a.boss_id,
        a.company_id,
        a.job_city
    from
        job_info a
    where 
        year(a.post_time) >= 2021
    union
    select
        b.job_id,
        b.boss_id,
        b.company_id,
        b.job_city
    from
        job_info b
    where
        b.job_city = '上海') tmp
order by
    tmp.job_city