Completed
Incomplete
Not Attended
Share
Reliance Mart has decided to create a digital shopping cart system to keep track of all the products purchased by customers. As a database administrator, you are responsible for managing this system. The database contains product information, including product names, categories, prices, and stock. You need to handle various customer and inventory requests.
Question - 1A customer wants to know the total number of products available in Reliance Mart. Can you provide this information?
Question - 2The stock of 'Shampoo' is running low. Update the stock to 100 units and display the updated information for 'Shampoo'.
Question - 3A batch of expired 'Biscuits' was discovered. Can you remove this product from the database and show all remaining products?
Question - 4The manager wants to know the total value of all products in stock. Can you calculate the total value of the inventory?
Question - 5A new product, 'Hand Sanitizer', has been introduced to the Personal Care category. It costs ₹150 and has 200 units in stock. Can you add this product to the database and display its details?
Code Editor
Table Name: products
| id | name | category | price | stock |
|---|---|---|---|---|
| 1 | Rice | Groceries | 500.00 | 100 |
| 2 | Shampoo | Personal Care | 200.00 | 50 |
| 3 | Biscuits | Snacks | 50.00 | 200 |
| 4 | Washing Powder | Home Care | 300.00 | 80 |
>>> Submit Your Query to validate