Course Content
Introduction to SQL
Introduction to SQL
Challenge: Budget-Friendly Books
The library decides to put some of the books on sale. A patron comes to you with a limited budget and asks for books that cost $20 or less. Your task is to compile a list of all the affordable options within their budget.
Swipe to show code editor
Write an SQL query to fetch the titles of all the books from the book_store table, where the price is less than or equal to 20.
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: Budget-Friendly Books
The library decides to put some of the books on sale. A patron comes to you with a limited budget and asks for books that cost $20 or less. Your task is to compile a list of all the affordable options within their budget.
Swipe to show code editor
Write an SQL query to fetch the titles of all the books from the book_store table, where the price is less than or equal to 20.
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