Level 3 - IntermediateOutput Prediction Questions
Output: Unmatched Customer Count
How many rows are returned? SELECT c.id FROM customers c LEFT JOIN orders o ON c.id = o.customer_id WHERE o.id IS NULL;
How many rows are returned? SELECT c.id FROM customers c LEFT JOIN orders o ON c.id = o.customer_id WHERE o.id IS NULL;