题解 | 查询职位发布时间在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 = '上海'
        order by
            job_city
    ) a