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