Self-contained subquery