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.
Swipe to start coding
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.
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Summarize this chapter
Explain the code in file
Explain why file doesn't solve the task
Awesome!
Completion rate improved to 1.72
Challenge: Sorting the Library Catalogue
Swipe to show menu
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.
Swipe to start coding
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.
Solution
Thanks for your feedback!
Awesome!
Completion rate improved to 1.72single