1 - Count the total number of products in each category.
Input Table: Products
Output: Category, Product_Count

2 - Calculate average weight of products by size.
Input Table: Products
Output: Size, Avg_Weight

3 - Find total sales amount for each customer.
Input Tables: Sales_Transactions, Customers
Output: Customer_ID, Customer_Name, Total_Sales

4 - List categories with more than 5 products.
Input Table: Products
Output: Category, Product_Count

5 - Show the earliest and latest sale dates for each product.
Input Table: Sales_Transactions
Output: SKU_Code, First_Sale_Date, Last_Sale_Date

6 - Calculate average sale amount by month, only for months with over 10 transactions.
Input Table: Sales_Transactions
Output: Month, Avg_Sale_Amount

7 - Find products that have been sold in more than 3 different transactions.
Input Table: Sales_Transactions
Output: SKU_Code, Transaction_Count

8 - List customers who spent more than ₹5000 in total, sorted by highest spenders.
Input Tables: Sales_Transactions, Customers
Output: Customer_ID, Customer_Name, Total_Spent

9 - Calculate the percentage each product contributes to total inventory value.
Input Tables: Inventory, Pricing
Output: SKU_Code, Inventory_Value, Percentage_Total

10 - Find sizes where the average product weight differs by more than 0.1kg from the overall average.
Input Table: Products
Output: Size, Avg_Weight, Overall_Avg_Difference

11 - Identify products with sales amounts that vary by more than ₹500 between their minimum and maximum sale.
Input Table: Sales_Transactions
Output: SKU_Code, Min_Sale_Amount, Max_Sale_Amount, Amount_Variation

12 - Show warehouse operation types that account for more than 20% of total operations.
Input Table: Warehouse_Ops
Output: Operation_Type, Operation_Count, Percentage_Total

13 - Find customers who purchased from at least 3 different product categories.
Input Tables: Sales_Transactions, Products, Customers
Output: Customer_ID, Customer_Name, Distinct_Categories

14 - Calculate the running percentage of total sales by product category over time.
Input Tables: Sales_Transactions, Products
Output: Sale_Date, Category, Daily_Sales, Percentage_Total

15 - Identify products that consistently sold within 10% of their average quantity per transaction.
Input Table: Sales_Transactions
Output: SKU_Code, Avg_Quantity, Min_Quantity, Max_Quantity