Course Content
Introduction to SQL
Introduction to SQL
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 show code editor
Write an SQL query which fetches the titles, authors, publication dates, and prices 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!
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 show code editor
Write an SQL query which fetches the titles, authors, publication dates, and prices 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!
Switch to desktop for real-world practiceContinue from where you are using one of the options below