SELECT j.company_id, SUM(d.resume_if_checked) AS cnt
FROM job_info AS j
LEFT JOIN deliver_record AS d
ON j.job_id = d.job_id
WHERE d.resume_if_checked > 0
GROUP BY j.company_id
ORDER BY j.company_id