SQL From Zero to Hero in 30 Days — Day 4 The Group by
Learn, practice, master.
The links below will be updated as we progress into the series:
- Day 1: Introduction
- Day 2: The Select
- Day 3: Filtering
- Day 4: The Group by
- Day 5: Expanding the Group by
- Day 6: Working With Text
- Day 7: Working With Text 2
- Day 8: Date Manipulation
Welcome to day 4 of this series!
In this article, we will do several examples that include the group by statement.
I often mention that SQL is much more than a query language. If used properly, it is a highly efficient data analysis and manipulation tool as well.
The group by statement is an integral part of what makes SQL a data analysis tool. If you are familiar with some other data analysis tools such as Pandas, the group by statement is quite similar to the groupby function of Pandas.
Some of the examples will also include the where statement which we covered on day 3. If you are not familiar with it, I suggest you take a quick look at the article of day 3 first.
