select job_id, boss_id, company_id
from job_info
where post_time >= '2021-01-01' or job_city = '上海'-- 要去重且排序，直接用or
order by job_city