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