SQL Practice Problems - Day 11
Focus: Data Manipulation Language (DML) Operations

1 - Update all product weights by adding 0.1kg for products in 'Men' category.
Input Table: Products
Output: Updated product weights

2 - Insert a new customer record with basic information.
Input Table: Customers
Output: New customer record

3 - Delete all sales transactions older than 2 years.
Input Table: Sales_Transactions
Output: Removed old transactions

4 - Update TP prices by 10% for products with sales below average.
Input Tables: Pricing, Sales_Transactions
Output: Updated pricing records

5 - Insert multiple warehouse operation records in a single transaction.
Input Table: Warehouse_Ops
Output: New operation records

6 - Delete products that have no sales and no inventory.
Input Tables: Products, Sales_Transactions, Inventory
Output: Removed product records

7 - Update customer names to uppercase for customers with purchases over ₹5000.
Input Tables: Customers, Sales_Transactions
Output: Updated customer names

8 - Insert sales transactions from a temporary staging table.
Input Tables: Sales_Transactions (target), Sales_Staging (source)
Output: New sales records

9 - Delete duplicate warehouse operations keeping the latest record.
Input Table: Warehouse_Ops
Output: Deduplicated operations

10 - Update inventory quantities after processing outbound operations.
Input Tables: Inventory, Warehouse_Ops
Output: Updated inventory levels

11 - Insert products from a supplier feed with conflict handling.
Input Tables: Products (target), Supplier_Feed (source)
Output: New/updated product records

12 - Delete customers with no purchases in the last 365 days.
Input Tables: Customers, Sales_Transactions
Output: Removed customer records

13 - Update sales amounts with currency conversion rates.
Input Tables: Sales_Transactions, Exchange_Rates
Output: Updated sales amounts

14 - Insert inventory records for new products with default values.
Input Tables: Inventory, Products
Output: New inventory records

15 - Archive old sales transactions to a history table then delete from main table.
Input Tables: Sales_Transactions, Sales_History
Output: Archived and cleaned data