题解 | #查询被投递过的职位信息#
查询被投递过的职位信息
https://www.nowcoder.com/practice/b4e9b51872b7473e8e906bcd25948859
select
company_id,
count(*) 'cnt'
from
deliver_record d,
job_info j
where
d.job_id = j.job_id
and d.resume_if_checked = 1
group by
company_id
order by
company_id;
投递中移(苏州)软件技术有限公司等公司10个岗位 >