# Aggregate Functions

There are functions in SQL that returns single line result among a group of the rows. These functions are called **aggregate functions**.

**MIN()** and **MAX()** functions return the minimum and maximum result from the query, and this is always a single line. 

Let's find the release date of the oldest song in our table:

Now, let's select the `price` of the most expensive song of 21st century:

SELECT MAX(price) FROM songs
WHERE year > 2000

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL Min and Max

Aggregate Functions

Lösning