practical-sql

practical-sql copied to clipboard

missing "," in chapter 6

7

" ➌ 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

marcosfromrio

regexp_matches queries returning no data

6

Taking this issue up based on chapter notes. ``` SELECT crime_id, regexp_matches(original_text, '-\d{1,2}\/\d{1,2}\/\d{2}') FROM crime_reports; ``` Returned no data when I ran it, and checking the underlying data it was...

jberkus

Inclusion of COPY statements in DDL files prevents readers from simply loading them.

3

Hey, your tech reviewer here. Example: https://github.com/anthonydb/practical-sql/blob/master/Chapter_08/Chapter_08.sql The COPY statements are interspersed with table definition statements. The problem with this is that the COPY statements are going to be specific...

jberkus