Course Content
Introduction to SQL
Introduction to SQL
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 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.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
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 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.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Switch to desktop for real-world practiceContinue from where you are using one of the options below