Completed
Incomplete
Not Attended
Share
The local chocolate distribution center needs to manage various chocolate types, their stock, and transactions. You are tasked with setting up the database schema, populating it with data, and querying it to ensure proper management.
Question - 1Add a new type of chocolate, 'Berry Bliss', with 50 quantities and a price of 200 INR and show the inserted data.
Question - 2Update the quantity of 'Milk Magic' to 250 and display the updated record.
Question - 3Remove 'Nutty Crunch' from the inventory and display the remaining chocolates.
Question - 4Retrieve all chocolate names and their prices sorted by price in descending order.
Question - 5Find the total number of chocolates in stock and display the result.
Code Editor
Table Name: chocolates
| id | name | type | quantity | price |
|---|---|---|---|---|
| 1 | Dark Delight | Dark | 100 | 150.00 |
| 2 | Milk Magic | Milk | 200 | 120.00 |
| 3 | Nutty Crunch | Nut | 150 | 180.00 |
>>> Submit Your Query to validate