1 - Retrieve all product details from the Products table.
Input Table: Products
Output: All columns from Products

2 - Find customers who made purchases in June 2021.
Input Table: Sales_Transactions, Customers
Output: Customer_ID, Customer_Name, Date

3 - List all products with stock quantity less than 100.
Input Table: Inventory, Products
Output: SKU_Code, Design_No, Category, Stock_Qty

4 - Show the total sales amount for each customer.
Input Table: Sales_Transactions, Customers
Output: Customer_ID, Customer_Name, Total_Sales

5 - Display products with their MRP prices sorted by highest price.
Input Table: Pricing, Products
Output: SKU_Code, Design_No, Final_MRP (descending order)

6 - Find products that have never been sold.
Input Table: Products, Sales_Transactions
Output: SKU_Code, Design_No, Category

7 - Calculate the average sale amount per transaction by month.
Input Table: Sales_Transactions
Output: Month, Average_Sale_Amount

8 - Identify customers who purchased more than 2 items in a single transaction.
Input Table: Sales_Transactions, Customers
Output: Customer_ID, Customer_Name, Date, Quantity

9 - Show warehouse operations that involved more than 50 items.
Input Table: Warehouse_Ops
Output: Operation_ID, Operation_Type, Quantity

10 - Find products that have different prices across platforms.
Input Table: Pricing
Output: SKU_Code, COUNT(distinct Amazon_MRP, Flipkart_MRP, etc.)

11 - Calculate inventory turnover rate for each product.
Input Table: Inventory, Sales_Transactions
Output: SKU_Code, Design_No, Turnover_Rate

12 - Identify the most popular product category by sales volume.
Input Table: Sales_Transactions, Products
Output: Category, Total_Quantity_Sold

13 - Find customers who purchased from multiple categories.
Input Table: Sales_Transactions, Products, Customers
Output: Customer_ID, Customer_Name, COUNT(distinct Category)

14 - Calculate profit margin for each product (assuming TP is cost price).
Input Table: Pricing, Sales_Transactions
Output: SKU_Code, Design_No, Profit_Margin

15 - Create a monthly sales report with comparisons to previous month.
Input Table: Sales_Transactions
Output: Month, Current_Sales, Previous_Month_Sales, Growth_Percentage