Course Content

SQL Tutorial for Beginners

1. Database & Introduction to Syntax

Meet the SQL Select the Songs!SQL Select Column SQL Distinct SQL Where Challenge Where SQL And, Or, Not

2. SQL Aggregate Functions

SQL Min and Max Challenge Min and Max SQL Count, Sum, Avg Challenge Count

3. Filtering Statements

SQL Null SQL Like Challenge Like SQL Between SQL Order By Challenge Order By SQL Group By Challenge Group By SQL Top and Limit SQL Aliases SQL Having Challenge Having SQL Comments

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

Task

Find the price of the most expensive song.

Task

Find the price of the most expensive song.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 2. Chapter 1

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

Task

Find the price of the most expensive song.

Task

Find the price of the most expensive song.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 2. Chapter 1

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

Task

Find the price of the most expensive song.

Task

Find the price of the most expensive song.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

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

Task

Find the price of the most expensive song.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Section 2. Chapter 1

Switch to desktop for real-world practiceContinue from where you are using one of the options below