Зміст курсу

SQL Tutorial for Beginners

1. Database & Introduction to Syntax

2. SQL Aggregate Functions

3. Filtering Statements

SQL Min and Max

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:


              1
            
SELECT MIN(year) FROM songs

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


              12
            
SELECT MAX(price) FROM songs
WHERE year > 2000

Завдання

Find the price of the most expensive song.

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 2. Розділ 1

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:


              1
            
SELECT MIN(year) FROM songs

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


              12
            
SELECT MAX(price) FROM songs
WHERE year > 2000

Завдання

Find the price of the most expensive song.

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 2. Розділ 1

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:


              1
            
SELECT MIN(year) FROM songs

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


              12
            
SELECT MAX(price) FROM songs
WHERE year > 2000

Завдання

Find the price of the most expensive song.

Все було зрозуміло?

Дякуємо за ваш відгук!

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:


              1
            
SELECT MIN(year) FROM songs

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


              12
            
SELECT MAX(price) FROM songs
WHERE year > 2000

Завдання

Find the price of the most expensive song.

Секція 2. Розділ 1