select job_id
     , boss_id
     , company_id
   from job_info
 where year(post_time)>='2021'
   or job_city like "上海%"
 order by job_city asc

其实这题很见简单不要想复杂了，限定条件就or就可以