It is sometimes useful to specify a condition on a group.
Example: Find customers owing more than $100
First: Find all customers and what they owe
select name, address, sum(unpaid)
from purchase join customer using (customer_id)
group by customer_id, name, address
Second: How to modify the query to find customers owing more than $100?