Set operations
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.