题解 | #查询每个公司查看过的投递用户数#

select
    job_info.company_id,
    count(*) cnt
from job_info join deliver_record
on job_info.job_id=deliver_record.job_id
where deliver_record.resume_if_checked=1
group by job_info.company_id
order by job_info.company_id asc