题解 | #查询每个公司查看过的投递用户数#
查询每个公司查看过的投递用户数
https://www.nowcoder.com/practice/3e40ce574a484b64b88781ac0b1340e8
select
company_id,
count(user_id) as cnt
from
(
select
j.company_id,
d.user_id
from
deliver_record as d
left join job_info as j on d.job_id = j.job_id
where
d.resume_if_checked != 0
) as new
group by company_id
order by company_id;
