A LEFT JOIN has a condition in the WHERE clause referencing the right table. What is the effect?

SELECT c.name, o.total FROM customers c LEFT JOIN orders o ON c.id = o.customer_id WHERE o.total > 100;