Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Aprenda Challenge: Decades | SQL Tasks
Data Manipulation using SQL

book
Challenge: Decades

Tarefa

Swipe to start coding

  1. Group songs into decades. Your result should record in such a format: Decade, songs.id, songs.title, songs.price. For example:

1970 5 Time 200

1970 4 Stairway to Heaven 510

1980 16 Billie Jean 1200

And so on for all the songs.

For songs from one decade, sort them, starting from the most expensive.

  1. Change your query to not include albums with the undefined decade.

Solução

SELECT albums.year - albums.year % 10 AS year, songs.id, songs.title, songs.price
FROM songs
INNER JOIN albums
ON albums.id = songs.album_id
WHERE year is not NULL
ORDER BY year, songs.price DESC

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 3. Capítulo 4
SELECT _ _ _ AS year, _ _ _
FROM songs
INNER JOIN _ _ _
WHERE _ _ _
ORDER BY _ _ _
Query ResultQuery Result
No query executed yet...

Pergunte à IA

expand
ChatGPT

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

some-alt