Completed
Incomplete
Not Attended
Completed
Incomplete
Not Attended
Vega Electronics is a leading electronics retailer, managing a variety of products
from multiple suppliers. Each product has a unique product ID, name, category, quantity in
stock, and supplier information. The warehouse manager wants to monitor stock availability,
calculate total quantity per product category, and update stock levels when new shipments
arrive. Your role is to write SQL queries to help manage inventory efficiently.
List all products in the 'Accessories' category
Calculate total quantity available for each category.
| product_id | product_name | category | quantity | supplier |
|---|---|---|---|---|
| 1 | Laptop | Computers | 10 | TechSupply |
| 2 | Mouse | Accessories | 50 | MouseWorld |
| 3 | Keyboard | Accessories | 30 | KeyMasters |
| 4 | Monitor | Displays | 15 | ViewTech |
| 5 | Printer | Peripherals | 5 | PrintWorks |
