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