missing "," in chapter 6

[marcossouzadotdev]

"
➌ SELECT c2010.geo_name,
c2010.state_us_abbreviation AS state,
c2010.p0010001 AS pop_2010,
c2000.p0010001 AS pop_2000
c2010.p0010001 - c2000.p0010001 AS raw_change,
"

missing "," in line 4

im reading the book on learning.oreilly

[anthonydb]

Hello, @marcosroot -- thanks for letting me know. It seems that error is present in the Kindle version as well. However, the code is correct in the print copies and PDF versions. I will alert the publisher and hopefully they can provide an update to O'Reilly.

[anthonysim]

The section of this code (Listing 6-13) that states:

FROM us_counties_2010 c2010 INNER JOIN us_counties_2000 c2000

Is it missing "AS" for the aliases c2010 and c2000?

[anthonydb]

@anthonysim That line of code is correct as-is. Although you could insert AS before the table alias, it's not required. In fact, you can even omit AS when aliasing column names in queries.

Here's a good discussion for more: https://stackoverflow.com/questions/4164653/whats-the-purpose-of-sql-keyword-as

[marcossouzadotdev]

i read this book on O'Reilly (Media) plataform, maybe the version on the site is equal the kindle/pdf version

[marcossouzadotdev]

I think there must be other errors, because I read only until Chapter 7, if there is more I will comment here

[lechter69]

I am apparently overthinking chapter 6 "try it yourself" # 2. The median() tells me the function can not be created for some reason. the percentile_cont will tell me there is not enough info. I am trying to manipulate the code, but it is not successful.

[anthonydb]

@lechter69
You're using the first edition of Practical SQL, and unfortunately a handful of the code examples in it will no longer work due to changes in PostgreSQL. The median() function is one of them -- it's no longer possible to create it as written.

Please paste the code you're using for percentile_cont() here. Also, you can always look at the Try It Yourself answers in this repo.