题解 | 查询被投递过的职位信息
查询被投递过的职位信息
https://www.nowcoder.com/practice/b4e9b51872b7473e8e906bcd25948859
select company_id, count(resume_if_checked) cnt from job_info j left join deliver_record d on j.job_id = d.job_id where resume_if_checked <> 0 group by company_id order by company_id