In “Sorting Query results” in Chapter 3, the word “aggregates” has been dropped from this sentence:
“Adaptive Server does not allow subqueries, variables and constant expressions in the order by list.” A successful example in the following section, order by and group by, uses the aggregate function avg(price) in an order by clause:
order by avg(price)
