Summarizing data

Intermediate SQL

Jasmin Ludolf

Data Science Content Developer, DataCamp

Summarizing data

  • Aggregate functions return a single value

Photograph showing a stack of papers and a magnifying glass

Intermediate SQL

Aggregate functions

AVG(), SUM(), MIN(), MAX(), COUNT()

SELECT AVG(budget)
FROM films;

|avg             |
|----------------|
|39902826.2684...|

 

SELECT SUM(budget)
FROM films;

|sum         |
|------------|
|181079025606|
Intermediate SQL

Aggregate functions

SELECT MIN(budget)
FROM films;

|min|
|---|
|218|

SELECT MAX(budget)
FROM films;

|max        |
|-----------|
|12215500000|
Intermediate SQL

Non-numerical data

Numerical fields only

  • AVG()
  • SUM()

Various data types

  • COUNT()
  • MIN()
  • MAX()
Intermediate SQL

Non-numerical data

MIN() <-> MAX()

Minimum <-> Maximum

Lowest <-> Highest

A <-> Z

1715 <-> 2022

0 <-> 100

Intermediate SQL

Non-numerical data

SELECT MIN(country)
FROM films;

|min        |
|-----------|
|Afghanistan|

SELECT MAX(country)
FROM films;

|max         |
|------------|
|West Germany|
Intermediate SQL

Aliasing when summarizing

SELECT MIN(country)
FROM films;

|min        |
|-----------|
|Afghanistan|

SELECT MIN(country) AS min_country
FROM films;

|min_country|
|-----------|
|Afghanistan|
Intermediate SQL

Let's practice!

Intermediate SQL

Preparing Video For Download...