题解 | #查询每个公司查看过的投递用户数#
查询每个公司查看过的投递用户数
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
刷题!刷题! 文章被收录于专栏
刷题一键转化~~