Tricky~24min
The Notification Black Hole
Churn is up and retention emails are supposedly catching at-risk users before they leave. The retention team swears the "we miss you" campaigns are running. Pull the email delivery logs and find out who actually received them.
Tables you'll query
usersemail_logs
What you'll learn
SubqueriesJOINsNULL Handling