SQL for Data Analytics - Third Edition

4. Aggregate Functions for Data Analysis

Overview

In this chapter, you will study the conceptual logic of aggregate functions, write SQL to execute these functions, and learn how to analyze data using them. You will also learn how to modify them using keywords such as HAVING and GROUP BY.

By the end of this chapter, you will be able to apply these functions to gain new insights into data and understand the properties of datasets, such as data quality.

Introduction

In the previous chapter, you learned how to use SQL to prepare datasets for analysis. Eventually, the purpose of data preparation is to make the data suitable for analysis so that you can make sense of it. Once the data has been prepared, the next step is to analyze it. Generally, ...