题解 | #查询每个公司查看过的投递用户数#
查询每个公司查看过的投递用户数
https://www.nowcoder.com/practice/3e40ce574a484b64b88781ac0b1340e8
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 否则会包含进未查看的
