I actually like the SQL example.
(select (num name)
:from customers
:where (exists (select name
:from orders
:where (and (= customers.num
orders.customer_num)
(< price 50)))))