题解 | #查询每个公司查看过的投递用户数#
查询每个公司查看过的投递用户数
https://www.nowcoder.com/practice/3e40ce574a484b64b88781ac0b1340e8
select company_id,sum(resume_if_checked) cnt from job_info,deliver_record where deliver_record.job_id=job_info.job_id and resume_if_checked=1 group by company_id order by company_id;
投递CVTE等公司6个岗位
查看3道真题和解析