select ji.company_id,sum(dr.resume_if_checked) cnt from job_info ji left join deliver_record dr on ji.job_id = dr.job_id group by ji.company_id having sum(dr.resume_if_checked) > 0 order by ji.company_id