Duplicate support tickets from the same customer

Question

Support wants to merge duplicate tickets. A duplicate is the **same customer raising the same issue category more than once on the same day**.

From `support_tickets`, return `customer_code`, `issue_category`, `raised_on` and `ticket_count` for every such duplicated combination.

Accepted Answer

Step 1: Translate the business definition of “duplicate” into a grouping key: customer + issue category + date. All three columns go into the `GROUP BY`. Step 2: `COUNT(*)` tells you how many tickets landed in each of those buckets. Step 3: Keep only buckets with more than one ticket using `HAVING COUNT(*) > 1` — the filter applies to the aggregate, so it cannot live in `WHERE`. Step 4: Project the three key columns plus the count so support knows how many tickets to merge.

Duplicate support tickets from the same customer

More GROUP BY questions

Asked at Zomato