题解 | #查询每个公司查看过的投递用户数#
查询每个公司查看过的投递用户数
https://www.nowcoder.com/practice/3e40ce574a484b64b88781ac0b1340e8
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
刷题！刷题！ 文章被收录于专栏
刷题一键转化~~
那就小心你的腰子咯