DataLemur: Duplicate Job Listings

1
2
3
4
5
6
7

SELECT COUNT(*) AS co_w_duplicate_jobs
FROM (
  SELECT company_id
  FROM job_listings
  GROUP BY company_id, title, description
  HAVING COUNT(*) > 1
) AS companies_with_duplicate_jobs