Course Content
Introduction to SQL
Introduction to SQL
Challenge: Affordable Books
At the book sale, the library is also running a promotion to highlight recent affordable books. As a librarian your task is to create a list of the 20 cheapest books published after the year 2015 to showcase in the promotional section.
Swipe to show code editor
Write an SQL query to retrieve the title, author, price, and publication_year of 20 cheapest books, sorted by their price in ascending order.
Don’t forget that these books need to have been published after 2015.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Challenge: Affordable Books
At the book sale, the library is also running a promotion to highlight recent affordable books. As a librarian your task is to create a list of the 20 cheapest books published after the year 2015 to showcase in the promotional section.
Swipe to show code editor
Write an SQL query to retrieve the title, author, price, and publication_year of 20 cheapest books, sorted by their price in ascending order.
Don’t forget that these books need to have been published after 2015.
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