题解 | 查询被投递过的职位信息
select j.company_id, sum(d.resume_if_checked) cnt from deliver_record d join job_info j on d.job_id = j.job_id group by j.company_id having cnt !=0 order by j.company_id
select j.company_id, sum(d.resume_if_checked) cnt from deliver_record d join job_info j on d.job_id = j.job_id group by j.company_id having cnt !=0 order by j.company_id
相关推荐