How do you remove duplicates from a table named 'products' based on the 'product_name' column?

 DELETE p1

FROM products p1

INNER JOIN products p2 ON p1.product_name = p2.product_name

WHERE p1.id > p2.id;