Getting Started with SQL

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

Version Location Description Submitted By Date Submitted Date Corrected
Printed, PDF
Page 43
First paragraph

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 FROM station_data 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.

Satishchandra Singh  Mar 06, 2016 
Printed, PDF, Mobi, Safari Books Online
Page 1679 (Kindle)
Appendix A5

One of the examples I put in Appendix A5 is incorrect. "state like 'D_l%'" should actually be "city like 'D_l%'"

Thomas Nield
Thomas Nield
Mar 06, 2016