Level 3 - IntermediateOptimization Questions
Optimization: EXISTS vs JOIN for Presence Check
Choose the better query for checking whether customers have at least one paid order, then provide final SQL. Query A: SELECT DISTINCT c.id FROM customers c JOIN orders o ON c.id = o.customer_id WHERE o.status = 'PAID'; Query B: SELECT c.id FROM customers c WHERE EXISTS (SELECT 1 FROM orders o WHERE o.customer_id = c.id AND o.status = 'PAID');