题解 | #查询每个公司查看过的投递用户数#
查询每个公司查看过的投递用户数
https://www.nowcoder.com/practice/3e40ce574a484b64b88781ac0b1340e8
select ji.company_id,sum(dr.resume_if_checked) cnt from job_info ji left join deliver_record dr on ji.job_id = dr.job_id group by ji.company_id having sum(dr.resume_if_checked) > 0 order by ji.company_id