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