Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Aggregate Functions

Introduction

We've learned how to write queries to retrieve information from the database. Now, we are going to learn how to perform calculations using SQL.

Calculations performed on multiple rows of a table are called aggregates.

In this lesson, we have given you a table named fake_apps which is made up of data on fake mobile applications.

Here is a quick preview of some important aggregates that we will cover in the next five exercises:

  • COUNT: count the number of values
  • SUM: add up all of the values in a column
  • MAX/MIN: get the largest/smallest value
  • AVG: get the mean for all values in a column
  • ROUND: round the values in the column

Let's get started!

Report a Bug
If you see a bug or any other issue with this page, please report it here.