题解 | 查询被投递过的职位信息
查询被投递过的职位信息
https://www.nowcoder.com/practice/b4e9b51872b7473e8e906bcd25948859
SELECT
t2.company_id,
SUM(t1.resume_if_checked) AS cnt
FROM deliver_record AS t1
JOIN job_info AS t2 ON t1.job_id = t2.job_id
GROUP BY t2.company_id -- 别加引号！
HAVING cnt > 0 -- 过滤掉总数为0的公司
ORDER BY t2.company_id; -- 别加引号！
查看7道真题和解析