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

select
    job_id,
    boss_id,
    company_id
from 
    job_info
where
    job_city='上海'

union 

select 
    job_id,
    boss_id,
    company_id
from
    job_info
where
    year(post_time)>=2021;