How to build Aggregation queries in Azure SQL or SQL Server 2019

Aggregation plays an important role in writing analytical queries for analytical reports or dashboards. We produce these reports for business for operational or decision making activities. In this video, I am showing the tricks of writing aggregation queries like count, count distinct, sum, average etc. It will help you understand the concept of aggregating information for analytical activities.

If you don't understand the data model used in this video. please watch following video.

If you don't understand the joins, please watch following videos