In Example 26 on page 121, the records are both grouped by and ordered by rep_num. What would the results
look like if you group by rep_num and order by average balance?
The arithmetic operators on page 106 do not include exponentiation. Do you think you can do exponentiation in
a SELECT statement? How would you do it?
Sorting means ordering records in a particular way. When would it be useful to sort data in ascending order?
Why? When would it be useful to sort data in descending order? Why?

Sample Solution