Completed
Incomplete
Not Attended
Share
Bookworm's Haven, a cozy independent bookstore, has decided to upgrade its inventory management system. As their new database consultant, you've been tasked with setting up and managing the store's book database. The database contains information about each book, including its title, author, publication year, genre, price, and current stock. Your job is to help the store owner and staff with various queries and updates to optimize their inventory and sales strategies.
Question - 1The store owner wants to know the total value of their current inventory. Can you calculate the total value (price * stock) of all books in the store?
Question - 2The staff is preparing for a genre-focused promotion. They need a list of all unique genres in the database, along with the count of books in each genre. Can you provide this information?
Question - 3The store decides to apply a 10% discount to all books published before 1950. Can you update the prices and then display the titles, original prices, and new prices of the affected books?
Question - 4A customer is looking for books that are either in the 'Fiction' genre or priced under $12. Can you provide a list of books that meet either of these criteria, showing the title, author, genre, and price?
Question - 5The store owner wants to identify books that are potentially overstocked. Find books with more than 10 copies in stock and calculate how many days it would take to sell all copies if they sold one per day. Then, display the title, current stock, and days to sell all copies, sorted by the number of days in descending order ?
Code Editor
Table Name: books
| id | title | author | publication_year | genre | price | stock |
| 1 | To Kill a Mockingbird | Harper Lee | 1960 | Fiction | 12.99 | 10 |
| 2 | 1984 | George Orwell | 1949 | Science Ficton | 10.99 | 15 |
| 3 | Pride and Prejudice | Jane Austen | 1813 | Romance | 9.99 | 5 |
| 4 | The Hobbit | J.R.R. Tolkien | 1937 | Fantasy | 14.99 | 20 |
| 5 | The Catcher in the Rye | J.D.Salinger | 1951 | Fiction | 11.99 | 8 |
>>> Submit Your Query to validate