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

select

    job_id,

    boss_id,

    company_id

from

    (

        select

            job_id,

            boss_id,

            company_id,

            job_city

        from

            job_info

        where

            post_time >= '2021-01-01'

            or job_city = '上海'

    ) t

order by

    job_city