SELECT company, AVG (net_amount), last_name FROM Sales GROUP BY company, last_name; The above example provides the average net_amount for each distinct last name in each company.