Find the duplicate records ruining your counts

My count is wrong: {{what you expected versus what you got}}. Here's the data: {{schema and 15 sample rows, including a few you suspect}}.

Work through duplicate types in this order and give me a query for each: exact row duplicates, same entity with a different id, same entity with formatting differences ({{case, whitespace, punctuation, phone and email formats}}), near-duplicates ({{typos, abbreviations, name order}}), and records that only look duplicated because a join fanned them out.

For each type: how many rows it likely affects, the query to list examples so I can eyeball them before deleting anything, and the rule for choosing which record survives.

Important: distinguish between duplicates and legitimately repeated events. If a row can honestly appear twice ({{a customer buying the same item twice}}), say so and tell me the field that separates the two cases.

Give me the safe fix as a view, not a delete.