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