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 Order By

To sort your result records, use ORDER BY construction. There is a syntax of query:


              12345
            
-- do not run this query
SELECT col1, col2, ...
FROM table
WHERE condition
ORDER BY some_col1, some_col2, ...

ORDER BY is at the end of the query, and sorts by one or multiple columns in their order. For example, if there is a construction ORDER BY singer, title, the result will be sorted by singer's name, but for multiple songs of the same singer, records will be sorted by title.

By default, sorting is in ascending order, but you can define it. Use ASC and DESC keywords after each column name:


              123
            
SELECT id, title, year
FROM songs
ORDER BY year DESC

ASC or DESC statement relates to the column name before it. It means, that in ORDER BY title ASC, price DESC first sorts by title in ascending order, and then by price in descending order.

Tarea

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

Tarea

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

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 3. Capítulo 5

SQL Order By

To sort your result records, use ORDER BY construction. There is a syntax of query:


              12345
            
-- do not run this query
SELECT col1, col2, ...
FROM table
WHERE condition
ORDER BY some_col1, some_col2, ...

By default, sorting is in ascending order, but you can define it. Use ASC and DESC keywords after each column name:


              123
            
SELECT id, title, year
FROM songs
ORDER BY year DESC

ASC or DESC statement relates to the column name before it. It means, that in ORDER BY title ASC, price DESC first sorts by title in ascending order, and then by price in descending order.

Tarea

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

Tarea

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

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 3. Capítulo 5

SQL Order By

To sort your result records, use ORDER BY construction. There is a syntax of query:


              12345
            
-- do not run this query
SELECT col1, col2, ...
FROM table
WHERE condition
ORDER BY some_col1, some_col2, ...

By default, sorting is in ascending order, but you can define it. Use ASC and DESC keywords after each column name:


              123
            
SELECT id, title, year
FROM songs
ORDER BY year DESC

ASC or DESC statement relates to the column name before it. It means, that in ORDER BY title ASC, price DESC first sorts by title in ascending order, and then by price in descending order.

Tarea

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

Tarea

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

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

¿Todo estuvo claro?

To sort your result records, use ORDER BY construction. There is a syntax of query:


              12345
            
-- do not run this query
SELECT col1, col2, ...
FROM table
WHERE condition
ORDER BY some_col1, some_col2, ...

By default, sorting is in ascending order, but you can define it. Use ASC and DESC keywords after each column name:


              123
            
SELECT id, title, year
FROM songs
ORDER BY year DESC

ASC or DESC statement relates to the column name before it. It means, that in ORDER BY title ASC, price DESC first sorts by title in ascending order, and then by price in descending order.

Tarea

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

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

Sección 3. Capítulo 5

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