Level 2 - JuniorOutput Prediction Questions
Output: LEFT JOIN Unmatched Row
Given the sample data below, what name will this query return? SELECT c.name FROM customers c LEFT JOIN orders o ON c.id = o.customer_id WHERE o.id IS NULL;
Given the sample data below, what name will this query return? SELECT c.name FROM customers c LEFT JOIN orders o ON c.id = o.customer_id WHERE o.id IS NULL;