Conteúdo do Curso
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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu 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.
Solução
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixoObrigado pelo seu feedback!
Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo