Errata

SQL for Data Analysis

Errata for SQL for Data Analysis

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
Printed Page not necessarily pages, but figures and charts from the book
figures and charts

The way the logic and queries are built by the author are very good and intuitive. But part of the analyzes are not performed on the tables generated by the queries, but on the charts of these queries. And how and where to make these charts is not explained by the author. Does she use Python, Power BI, DataBricks, or another tool?

Pedro Dias  May 08, 2023 
Printed Page Page 131
Line 13 of the code excerpt above

In the section "SQL for a Basic Retention Curve", the basic query for counting legislators was built piece by piece. "count(distinct a.id_bioguide) as cohort_retained" was used to avoid duplicates. However, in the specified code excerpt, "count(*)" was used.

This change increases the cohort size to 2647.

The printed result of the query is not reproducible.

Michael Stach  Aug 03, 2023