sql-ecology-lesson icon indicating copy to clipboard operation
sql-ecology-lesson copied to clipboard

Published 20 hours ago • verified publisher icon datacarpentry

Minor issue re: COUNT

Open pmarchand1 opened this issue 6 years ago • 1 comments

In episode 02, the section introducing HAVING starts using COUNT(species_id) instead of COUNT( * ), but the distinction between those two forms (how they treat NULL) is only explained later in the lesson. Perhaps it would be simpler to use COUNT(*) until the discussion of NULL values?

pmarchand1 avatar Apr 13 '18 19:04 pmarchand1