Solutions

1. 
   SELECT p.SKU_Code, p.Design_No, i.Stock_Qty
   FROM Products p
   INNER JOIN Inventory i ON p.SKU_Code = i.SKU_Code;
   

2. 
   SELECT c.Customer_ID, c.Customer_Name, s.Sale_ID
   FROM Customers c
   LEFT JOIN Sales_Transactions s ON c.Customer_ID = s.Customer_ID;
   

3. 
   SELECT p.SKU_Code, p.Design_No
   FROM Products p
   LEFT JOIN Sales_Transactions s ON p.SKU_Code = s.SKU_Code
   WHERE s.SKU_Code IS NULL;
   

4. 
   SELECT s.Sale_ID, s.SKU_Code, p.Design_No, p.Category, s.Quantity
   FROM Sales_Transactions s
   INNER JOIN Products p ON s.SKU_Code = p.SKU_Code;
   

5. 
   SELECT w.Operation_ID, w.SKU_Code, p.Category, w.Operation_Type
   FROM Warehouse_Ops w
   INNER JOIN Products p ON w.SKU_Code = p.SKU_Code;
   

6. 
   SELECT p.SKU_Code, p.Design_No, pr.Amazon_MRP, pr.Flipkart_MRP
   FROM Products p
   LEFT JOIN Pricing pr ON p.SKU_Code = pr.SKU_Code;
   

7. 
   SELECT c.Customer_ID, c.Customer_Name, p.SKU_Code, p.Weight
   FROM Customers c
   INNER JOIN Sales_Transactions s ON c.Customer_ID = s.Customer_ID
   INNER JOIN Products p ON s.SKU_Code = p.SKU_Code
   WHERE p.Weight > 0.3;
   

8. 
   SELECT s.Sale_ID, s.SKU_Code, s.Rate, p.TP_Price
   FROM Sales_Transactions s
   INNER JOIN Pricing p ON s.SKU_Code = p.SKU_Code
   WHERE s.Rate < p.TP_Price;
   

9. 
   SELECT p.SKU_Code, p.Design_No, COALESCE(SUM(s.Quantity), 0) AS Total_Sold
   FROM Products p
   LEFT JOIN Sales_Transactions s ON p.SKU_Code = s.SKU_Code
   GROUP BY p.SKU_Code, p.Design_No;
   

10. 
    WITH CategoryCounts AS (
      SELECT 
        c.Customer_ID,
        c.Customer_Name,
        p.Category,
        COUNT(*) AS purchase_count
      FROM Customers c
      JOIN Sales_Transactions s ON c.Customer_ID = s.Customer_ID
      JOIN Products p ON s.SKU_Code = p.SKU_Code
      GROUP BY c.Customer_ID, c.Customer_Name, p.Category
    )
    SELECT 
      Customer_ID,
      Customer_Name,
      Category AS Top_Category
    FROM (
      SELECT *,
        RANK() OVER (PARTITION BY Customer_ID ORDER BY purchase_count DESC) AS rank
      FROM CategoryCounts
    ) WHERE rank = 1;
    

11. 
    SELECT i.SKU_Code, i.Stock_Qty
    FROM Inventory i
    LEFT JOIN Pricing p ON i.SKU_Code = p.SKU_Code
    WHERE p.SKU_Code IS NULL;
    

12. 
    SELECT w.Operation_ID, w.SKU_Code, p.Design_No, pr.TP_Price, w.Operation_Type
    FROM Warehouse_Ops w
    INNER JOIN Products p ON w.SKU_Code = p.SKU_Code
    INNER JOIN Pricing pr ON w.SKU_Code = pr.SKU_Code;
    

13. 
    SELECT c.Customer_ID, c.Customer_Name, COUNT(DISTINCT p.Category) AS Category_Count
    FROM Customers c
    JOIN Sales_Transactions s ON c.Customer_ID = s.Customer_ID
    JOIN Products p ON s.SKU_Code = p.SKU_Code
    GROUP BY c.Customer_ID, c.Customer_Name
    HAVING COUNT(DISTINCT p.Category) = 2;
    

14. 
    SELECT 
      p.SKU_Code, 
      p.Design_No, 
      pr.Amazon_MRP, 
      pr.Flipkart_MRP,
      ABS(pr.Amazon_MRP - pr.Flipkart_MRP) AS Price_Difference
    FROM Products p
    JOIN Pricing pr ON p.SKU_Code = pr.SKU_Code
    WHERE ABS(pr.Amazon_MRP - pr.Flipkart_MRP) > 0.1 * GREATEST(pr.Amazon_MRP, pr.Flipkart_MRP);
    

15. 
    SELECT 
      p.SKU_Code,
      p.Design_No,
      COALESCE(SUM(s.Gross_Amount), 0) AS Total_Sales_Value,
      (i.Stock_Qty * pr.TP_Price) AS Inventory_Value
    FROM Products p
    LEFT JOIN Sales_Transactions s ON p.SKU_Code = s.SKU_Code
    INNER JOIN Inventory i ON p.SKU_Code = i.SKU_Code
    INNER JOIN Pricing pr ON p.SKU_Code = pr.SKU_Code
    GROUP BY p.SKU_Code, p.Design_No, i.Stock_Qty, pr.TP_Price;