Completed
Incomplete
Not Attended
Share
You are managing a small bookstore that specializes in adventure novels. The owner wants to keep track of books in stock, their prices, and categories. Your job is to help manage the books database and handle customer queries about book availability, pricing, and stock.
Question - 1A customer wants to know how many books are available in the bookstore. Can you provide this information?
Question - 2The stock of 'Treasure Island' has decreased after sales. Update the stock to 45 units.
Question - 3A new adventure book, 'Around the World in 80 Days,' is now in stock with 100 units and a price of ₹350. Add this book to the database.
Question - 4The manager wants to know the total value of books in stock. Can you calculate the total value?
Question - 5The book 'Moby Dick' has gone out of print. Can you remove it from the database?
Code Editor
Table Name: books
| id | title | category | price | stock |
|---|---|---|---|---|
| 1 | Treasure Island | Adventure | 299.99 | 50 |
| 2 | Moby Dick | Classic | 399.99 | 20 |
| 3 | The Odyssey | Epic | 499.99 | 30 |
>>> Submit Your Query to validate