题解 | 查询被投递过的职位信息
查询被投递过的职位信息
https://www.nowcoder.com/practice/b4e9b51872b7473e8e906bcd25948859
SELECT
j.company_id,
COUNT(DISTINCT dr.user_id) AS cnt
FROM
deliver_record dr
JOIN
job_info j ON dr.job_id = j.job_id
WHERE
dr.resume_if_checked = 1
GROUP BY
j.company_id
ORDER BY
j.company_id ASC;
题库答案被矫正过来了，但题解还是没有变化
