Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Challenge: Sorting the Library Catalogue | Sorting Data
Introduction to SQL
course content

Conteúdo do Curso

Introduction to SQL

Introduction to SQL

1. Getting Started
3. Sorting Data
4. Populating a Database
5. Updating & Deleting Data

book
Challenge: Sorting the Library Catalogue

While assisting people at your librarian post, someone approaches you, curious about books that have been published recently.

To help them, you decide to sort the books based on the publication year, such that the newest books are at the top.

Tarefa
test

Swipe to show code editor

Your task is to write an SQL query to select title, author, publication_year and genre of all the books and display them sorted based on the publication_year column according to the customer's requirements.

Solução

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 3. Capítulo 2
toggle bottom row

book
Challenge: Sorting the Library Catalogue

While assisting people at your librarian post, someone approaches you, curious about books that have been published recently.

To help them, you decide to sort the books based on the publication year, such that the newest books are at the top.

Tarefa
test

Swipe to show code editor

Your task is to write an SQL query to select title, author, publication_year and genre of all the books and display them sorted based on the publication_year column according to the customer's requirements.

Solução

Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 3. Capítulo 2
Switch to desktopMude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo
We're sorry to hear that something went wrong. What happened?
some-alt