Pro exercise

Missing values group together

Remove duplicate contacts that share an email and a phone. Many contacts have no phone, and two rows with the same email and no phone are duplicates too: GROUP BY and PARTITION BY treat missing values as one group, but a self-join on phone = phone never matches them.

• duplicates
• nulls
• sql

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.