题解 | #查询每个公司查看过的投递用户数#

select
    ji.company_id as company_id,
    count(distinct dr.user_id) as cnt
from
    job_info ji
    inner join deliver_record dr on dr.job_id = ji.job_id
    and dr.resume_if_checked = 1
    group by ji.company_id