Linkedin SQL Interview Question | DataLemur

SELECT COUNT(DISTINCT company_id) as duplicate_companies
FROM (
SELECT
COUNT(job_id) AS job_count,
company_id,
title,
description
from job_listings
GROUP BY company_id, title, description
) as job_count_cte
WHERE job_count>1;