题解 | #查询职位发布时间在2021年后或职位城市为上海的
查询职位发布时间在2021年后或职位城市为上海的job_id, boss_id, company_id
https://www.nowcoder.com/practice/8beaed9f153d4f65acda4db12ae55ddd
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
腾讯公司氛围 3634人发布
