Exercise · SQL & Querying
Predict, then run it
Predict the output
promo(email) = a@x, b@x. newsletter(email) = b@x, c@x. Every list membership is one email to send:
SELECT email FROM promo UNION ALL SELECT email FROM newsletter ORDER BY email;
Predict the exact output.