Try this problem in the playground
The sample tables will be auto-loaded — write a query and run it instantly.
Find customers with duplicate email addresses, then show how to keep only the most recent.
The playground will create these tables and populate them automatically when you click "Open Playground" above:
Multiple approaches — try each and understand the trade-offs.