select
company_id,
count(*) 'cnt'
from
deliver_record d,
job_info j
where
d.job_id = j.job_id
and d.resume_if_checked = 1
group by
company_id
order by
company_id;