There's plenty of cases - remove the people who have attribute, then aggregate them, then filter the aggregate. Find me the list of non-deleted users who have

There's plenty of cases - remove the people who have attribute, then aggregate them, then filter the aggregate. Find me the list of non-deleted users who have more than 50 dollars worth of transactions in the transaction table. Technically you can always subquery and use a where instead of a having but its nice to ... have.