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