Duplicate job listings
LinkedIn is looking for companies that post duplicate job listings. Find job listing groups with the same company_id, title, and description when such a group contains more than one record. Return company_id, title, description, and job_count — the number of records in the group.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| title | job_count | company_id | description |
|---|---|---|---|
| Product Manager | 4 | 5 | Define roadmap |
| Backend Dev | 2 | 2 | Build APIs |
| Data Analyst | 3 | 1 | Analyze data |
LinkedIn
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid