题解 | 查询每个公司查看过的投递用户数
查询每个公司查看过的投递用户数
https://www.nowcoder.com/practice/3e40ce574a484b64b88781ac0b1340e8
select company_id, sum(resume_if_checked) as cnt from deliver_record
left join job_info using(job_id)
where resume_if_checked>0
group by company_id
order by company_id
和上一道一模一样，垃圾VIP，纯属坑人。
进阶可以参考戴师兄的那道不同球队进球数题，用if+sum去判断