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

Spliting the COUNT & GROUP BY paragraph (02-sql-aggregation)

Open MathildeMousset opened this issue 5 years ago • 0 comments

I suggest to split the COUNT and GROUP BY section.

When I did the lesson, I was a confused because there is GROUP BY in the title, and the first sentence explains the concept of aggregating based on some value. Yet the next three examples and the challenge are not using GROUP BY.

I would suggest split this section in two:

Aggregating / summarizing all records

Aggregating based on field(s).

This sentence would then be moved at the begining of the second part:

Aggregation allows us to combine results by grouping records based on value, also it is useful for calculating combined values in groups.

MathildeMousset avatar Apr 30 '19 12:04 MathildeMousset