Kurssisisältö
Introduction to SQL
Introduction to SQL
Challenge: Further Sorting the Catalogue
In the last task, you were helping a customer look through books.
Following was the query we came up with:
sql
Since there are too many books in the library catalogue, it is hard for the customer to find a relevant book even after sorting by publication_year, since many books can have the same publication year.
You can further sort the books to make the results much easier to look through. For example, you can sort them by Genre, and then by the Title.
In places where multiple books have the same Publication Year, the query will sort the rows by Genre, and in case some of those rows have the same Genre, they'll be further sorted by the Title.
Swipe to start coding
Your task is to modify the query such that the fetches books are sorted according to the following columns (in the given order):
publication_yearin descending order;genrein ascending order;titlein ascending order.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
Challenge: Further Sorting the Catalogue
In the last task, you were helping a customer look through books.
Following was the query we came up with:
sql
Since there are too many books in the library catalogue, it is hard for the customer to find a relevant book even after sorting by publication_year, since many books can have the same publication year.
You can further sort the books to make the results much easier to look through. For example, you can sort them by Genre, and then by the Title.
In places where multiple books have the same Publication Year, the query will sort the rows by Genre, and in case some of those rows have the same Genre, they'll be further sorted by the Title.
Swipe to start coding
Your task is to modify the query such that the fetches books are sorted according to the following columns (in the given order):
publication_yearin descending order;genrein ascending order;titlein ascending order.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaKiitos palautteestasi!
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista