select j.company_id, sum(resume_if_checked) as cnt from deliver_record d join job_info j on j.job_id = d.job_id group by j.company_id having cnt > 0 order by j.company_id asc

select j.company_id, sum(resume_if_checked) as cnt from deliver_record d join job_info j on j.job_id = d.job_id group by j.company_id having cnt > 0 order by j.company_id asc