题解 | #查询职位发布时间在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
post_time >= '2021-01-01'
or job_city = '上海'
) t
order by
job_city
查看2道真题和解析