SELECT options refine results As we saw in the last article, the SQL SELECT statement ... The above example provides the average net_amount for each distinct last name in each company.