Duplicate job listings

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

company_idtitledescriptionjob_count
5Product ManagerDefine roadmap4
2Backend DevBuild APIs2
1Data AnalystAnalyze data3
LinkedIn

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid