Querying Subsets with Subqueries

Use nested queries to compute intermediate values required for a main filter.