题解 | #查询被投递过的职位信息#
查询被投递过的职位信息
https://www.nowcoder.com/practice/b4e9b51872b7473e8e906bcd25948859
select
j.job_id,boss_id,company_id,post_time,salary,job_city
from
deliver_record d right join
job_info j
on
d.job_id = j.job_id
and
resume_if_checked = 1
order by boss_id
