Contenido del Curso

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

Tarea

Find the price of the most expensive song.

Tarea

Find the price of the most expensive song.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 2. Capítulo 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

Tarea

Find the price of the most expensive song.

Tarea

Find the price of the most expensive song.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

Sección 2. Capítulo 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

Tarea

Find the price of the most expensive song.

Tarea

Find the price of the most expensive song.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

¿Todo estuvo claro?

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

Tarea

Find the price of the most expensive song.

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones

Sección 2. Capítulo 1

Cambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones