Tasks:

Task $1$: Inserting New Products Begin by populating the "Products" table with new product

entries. Write T$-$SQL statements to insert the following products:

$$ ProductName: "Laptop" Category: "Electronics" StockQuantity: $50$

$$ ProductName: "Running Shoes" Category: "Sportswear" StockQuantity: $120$

$$ ProductName: "Coffee Maker" Category: "Kitchen Appliances" StockQuantity: $30$

$$ ProductName: "Notebook" Category: "Stationery" StockQuantity: $200$

Task $2$: Updating Product Categories Proceed to update the category of the product "Coffee

Maker" to "Appliances."

Task $3$: Adjusting Stock Quantity As part of inventory management, adjust the stock quantity

of the product "Running Shoes" by reducing it to $100.$

Task $4$: Creating a Low Stock Alert View To facilitate inventory monitoring, create a T$-$SQL

view named "LowStockAlert" that displays products with a stock quantity less than $50.$ This view

should show the ProductName, Category, and StockQuantity.

Task $5$: Deleting Products Implement a process to remove products from the inventory. Write T$-$

SQL statements to delete the product with the ProductName "Notebook."

Task $6$: Restocking Products Simulate a restocking scenario by increasing the stock quantity of

the "Laptop" product by $20$ units.

Task $7$: Product Count by Category Create a query to retrieve a list of unique product categories

along with the count of products in each category.

Task $8$: Product Restock Recommendation Write a query to identify products that are running

low on stock $($quantity less than $50)$ and suggest restocking quantities for each of them.

Task $9$: Category Stock Sum Develop a query to calculate the total stock quantity for each

product category.

Task $10$: Expired Products Handling Suppose you have an "ExpirationDate" column for certain

products. Write a query to identify products that have expired and need to be removed from the