题解 | #查询每个公司查看过的投递用户数#
查询每个公司查看过的投递用户数
https://www.nowcoder.com/practice/3e40ce574a484b64b88781ac0b1340e8
select company_id, count(resume_if_checked) as cnt from job_info j inner join deliver_record d on j.job_id = d.job_id where resume_if_checked = 1 group by company_id order by company_id asc
别忘了筛选where！！