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. Your answer must use the same column names as this sample — alias them with AS if needed.

company_id	title	description	job_count
5	Product Manager	Define roadmap	4
2	Backend Dev	Build APIs	2
1	Data Analyst	Analyze data	3

Your query result will appear here

Focus radio

Paused · SomaFM · Fluid