select company_id, sum(if(resume_if_checked = 1,1,0)) cnt from deliver_record dr
inner join job_info ji on dr.job_id = ji.job_id
where resume_if_checked = 1
group by company_id
order by company_id

必须要加where resume_if_checked = 1 否则会包含进未查看的