job_posts(post_id, company_id, title, description, posted_at)

During 2026, find the listings a company posted more than once: the same company_id, title and description appearing two or more times.

Return company_id, title, description and duplicate_count, one row per repeated listing.

Same title with a different description is not a duplicate, and neither is the same listing from a different company.

Tables

job_posts

post_id  company_id  title         description                        posted_at
-------  ----------  ------------  ---------------------------------  ----------
1        100         Data Analyst  Own reporting and dashboards.      2026-02-01
2        100         Data Analyst  Own reporting and dashboards.      2026-04-11
3        100         Data Analyst  A different description entirely.  2026-05-01
4        200         Data Analyst  Own reporting and dashboards.      2026-03-01
5        300         ML Engineer   Ship models to production.         2026-06-01
6        300         ML Engineer   Ship models to production.         2025-06-01

Expected result

company_id  title         description                    duplicate_count
----------  ------------  -----------------------------  ---------------
100         Data Analyst  Own reporting and dashboards.  2