Set Operation Pipeline

How can we combine all order customers and then exclude blocked accounts?

Advanced⏱ 3 Minutes⭐ 1810 XP

🤔 THE QUESTION

How can we combine all order customers and then exclude blocked accounts?

💡 WHAT IS IT?

Chaining UNION with EXCEPT combines multiple sources and suppresses disqualified records in one pipeline.

🎯 WHAT IS IT USED FOR?

Marketing campaign audience generation, fraud suppression, compliance list generation.

💻 EXAMPLE

SELECT customer_id
FROM online_orders
UNION
SELECT customer_id
FROM store_orders
EXCEPT
SELECT customer_id
FROM blocked_customers;

Practice typing production-grade SQL code for Set Operation Pipeline.