Completed
Incomplete
Not Attended
Share
Tech Haven is a shop selling the latest tech gadgets. You are tasked with managing their inventory and helping with customer queries.
Question - 1List all the gadgets currently available in the store.
Question - 2The shop sold 5 Smartphones. Update the stock for 'Smartphone' .
Question - 3A new gadget, 'Smartwatch', is now available in the shop. Add this gadget with 100 units at ₹10,000 each.
Question - 4Calculate the average price of all gadgets available in the store
Question - 5The shop wants to run a discount promotion. Decrease the price of all gadgets by 5% and show the updated prices.
Code Editor
Table Name: gadgets
| id | name | category | price | stock |
|---|---|---|---|---|
| 1 | Smartphone | Mobile | 30000.00 | 40 |
| 2 | Laptop | Computer | 60000.00 | 20 |
| 3 | Tablet | Mobile | 25000.00 | 15 |
>>> Submit Your Query to validate