select company_id, sum(if(resume_if_checked = 1,1,0)) cnt from deliver_record dr inner join job_info ji on dr.job_id = ji.job_id where resume_if_checked = 1 group by company_id order by company_id
必须要加where resume_if_checked = 1 否则会包含进未查看的
select company_id, sum(if(resume_if_checked = 1,1,0)) cnt from deliver_record dr inner join job_info ji on dr.job_id = ji.job_id where resume_if_checked = 1 group by company_id order by company_id
必须要加where resume_if_checked = 1 否则会包含进未查看的