Challenge: Defining Ranges
In the Book Sale, there is a section for medium-priced books. It is supposed to contain books that cost more than $15 and less than $20. Your task is to make a list of all such books so they can be transferred to that section.
Swipe to start coding
Write an SQL query which fetches the titles, authors and publication dates of all the books that fall in the price range of 15 to 20 dollars (inclusive of 15 and 20).
Note
Use the
book_storetable.
The book_store table includes these columns: id, title, author, genre, publication_year, and price.
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.72Challenge: Defining Ranges
Swipe to show menu
In the Book Sale, there is a section for medium-priced books. It is supposed to contain books that cost more than $15 and less than $20. Your task is to make a list of all such books so they can be transferred to that section.
Swipe to start coding
Write an SQL query which fetches the titles, authors and publication dates of all the books that fall in the price range of 15 to 20 dollars (inclusive of 15 and 20).
Note
Use the
book_storetable.
The book_store table includes these columns: id, title, author, genre, publication_year, and price.
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
Awesome!
Completion rate improved to 1.72single
