How would you use SQL to find duplicate product listings?
Treat listings with the same product_name, brand, and category as duplicates. Return only attribute combinations appearing more than once.
product_name, brand, category, and listing_countlisting_count descending, then product attributes ascending with NULL values last| Column | Type | Description |
|---|---|---|
| listing_idPK | INT | Unique identifier for the listing |
| product_name | VARCHAR(150) | Name of the listed product |
| brand | VARCHAR(100) | Product brand |
| category | VARCHAR(100) | Product category |