题解 | #查询被投递过的职位信息#
查询被投递过的职位信息
https://www.nowcoder.com/practice/b4e9b51872b7473e8e906bcd25948859
# 能过的答案
select * from job_info
# 根据题意解
select company_id,
sum(resume_if_checked) as cnt
from
deliver_record as d
join
job_info as j
on d.job_id = j.job_id
group by company_id
having cnt != 0
order by company_id asc
，祝福佬前程似锦。