Customers who ever placed an order

Question

Accepted Answer

EXISTS returns TRUE if the subquery produces at least one row, FALSE if it produces none. For Alice (id=1), the subquery finds two orders - EXISTS is TRUE. For Bob and Carol (ids 2 and 3), the subquery finds no orders - EXISTS is FALSE. The SELECT 1 inside EXISTS is conventional - the actual value doesn't matter, only whether a row exists.