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