Errata for Getting Started with SQL
Submit your own errata for this product.
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update
Let’s move on to other aggregation tasks. If you wanted to find the average temperature
for each month since 2000, you could filter for years 2000 and later, group by
month, and perform an average on temp (Figure 6-4):
SELECT month, AVG(temp) as avg_temp
WHERE year >= 2000
GROUP BY month
In the above paragraph on page 43 and SQL query, the column name should be "temperature" instead of "temp".
Note from the Author or Editor:
That is correct. It should be temperature.
||Mar 06, 2016
|Printed, PDF, Mobi, Safari Books Online
Page 1679 (Kindle)
One of the examples I put in Appendix A5 is incorrect.
"state like 'D_l%'" should actually be "city like 'D_l%'"
|Mar 06, 2016