Find Customers with Duplicate Emails

Given a customers table where some customers may share the same email address (e.g. duplicate signups), write a self-join query that finds every pair of customer records sharing an email. Return the two customer IDs and the shared email, avoiding both self-pairs and duplicate reversed pairs.