select company_id, sum(resume_if_checked) as cnt from deliver_record

left join job_info using(job_id)

where resume_if_checked>0

group by company_id

order by company_id

和上一道一模一样，垃圾VIP，纯属坑人。

进阶可以参考戴师兄的那道不同球队进球数题，用if+sum去判断