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 = '上海'
) a
order by job_city