Re: Chapter 6 Example - Page 146
While the reader is not directly instructed to execute it, the SQL query shown on page 146 under the section heading "Sorting the Query" is not correct unless a GROUP BY clause is added (ahead of the ORDER BY) because the sales amount is aggregated in the SELECT statement. Alternatively, the sum function could be removed.
|