题解 | #我认为的正确答案#

select company_id,sum(resume_if_checked) as cnt

from deliver_record as a inner join job_info as b on a.job_id = b.job_id

group by company_id

having cnt<> 0

order by company_id