Daten zusammenfassen

SQL für Fortgeschrittene

Jasmin Ludolf

Data Science Content Developer, DataCamp

Foto, das einen Stapel Papiere und eine Lupe zeigt

Aggregatfunktionen

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

SELECT AVG(budget)
FROM films;

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

SELECT SUM(budget)
FROM films;

|sum         |
|------------|
|181079025606|

SELECT MIN(budget)
FROM films;

|min|
|---|
|218|

SELECT MAX(budget)
FROM films;

|max        |
|-----------|
|12215500000|

Ausschließlich numerische Felder

Verschiedene Datentypen

MIN() <-> MAX()

Minimum <-> Maximum

Niedrigste <-> Höchste

A <-> Z

1715 <-> 2022

0 <-> 100

SELECT MIN(country)
FROM films;

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

SELECT MAX(country)
FROM films;

|max         |
|------------|
|West Germany|

SELECT MIN(country)
FROM films;

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

SELECT MIN(country) AS min_country
FROM films;

|min_country|
|-----------|
|Afghanistan|

SQL für Fortgeschrittene