sql-ecology-lesson
sql-ecology-lesson copied to clipboard
Spliting the COUNT & GROUP BY paragraph (02-sql-aggregation)
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.