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

I personally find using * in the presence of GROUP BY somewhat unintuitive, but you are correct. I guess the change should be made?

remram44 avatar Apr 16 '18 21:04 remram44