A correlated subquery in a WHERE clause references the outer query's row. Conceptually, how is it evaluated, and what does that imply about a correlated EXISTS?
SELECT c.id
FROM customers c
WHERE EXISTS (
SELECT 1 FROM orders o WHERE o.cust_id = c.id
);