Problem 1

SELECT 
    i.SKU_Code, 
    (i.Stock_Qty * p.TP_Price) AS Inventory_Value
FROM Inventory i
JOIN Pricing p ON i.SKU_Code = p.SKU_Code
WHERE i.Stock_Qty < 100;


Problem 2

SELECT 
    SKU_Code, 
    TP_Price, 
    Final_MRP
FROM Pricing
WHERE Final_MRP = TP_Price * 1.5;


Problem 3

SELECT 
    Sale_ID, 
    Quantity, 
    Gross_Amount
FROM Sales_Transactions
WHERE (Quantity BETWEEN 3 AND 5) OR (Gross_Amount > 2000);


Problem 4

SELECT 
    p.SKU_Code, 
    p.Weight, 
    pr.Final_MRP
FROM Products p
JOIN Pricing pr ON p.SKU_Code = pr.SKU_Code
WHERE p.Category = 'Men' 
  AND p.Weight >= 0.3
  AND pr.Final_MRP != 2295;


Problem 5

SELECT 
    Operation_ID, 
    Operation_Type, 
    Quantity
FROM Warehouse_Ops
WHERE Quantity IN (1, 3, 5);


Problem 6

SELECT 
    SKU_Code,
    ROUND(((Amazon_MRP - Flipkart_MRP)/Flipkart_MRP)*100, 2) AS Price_Diff_Percentage
FROM Pricing;


Problem 7

SELECT 
    p.SKU_Code, 
    pr.TP_Price, 
    p.Category
FROM Products p
JOIN Pricing pr ON p.SKU_Code = pr.SKU_Code
WHERE pr.TP_Price % 2 = 1
  AND p.Category != 'Kids';


Problem 8

SELECT 
    s.Sale_ID, 
    s.Rate, 
    p.TP_Price
FROM Sales_Transactions s
JOIN Pricing p ON s.SKU_Code = p.SKU_Code
WHERE s.Rate < (0.8 * p.TP_Price) OR s.Rate > (1.2 * p.TP_Price);


Problem 9

WITH AvgStock AS (
    SELECT AVG(Stock_Qty) AS avg_val FROM Inventory
)
SELECT 
    SKU_Code, 
    Stock_Qty,
    (SELECT avg_val FROM AvgStock) AS Avg_Stock
FROM Inventory
WHERE Stock_Qty < (0.8 * (SELECT avg_val FROM AvgStock))
   OR Stock_Qty > (1.2 * (SELECT avg_val FROM AvgStock));


Problem 10

SELECT 
    c.Customer_ID, 
    s.Gross_Amount
FROM Customers c
JOIN Sales_Transactions s ON c.Customer_ID = s.Customer_ID
WHERE s.Date BETWEEN '2021-07-01' AND '2021-09-30'
  AND s.Gross_Amount NOT IN (500, 1000, 1500);


Problem 11

SELECT 
    Sale_ID, 
    Gross_Amount,
    ROUND(Gross_Amount * 0.9, 2) AS Net_Amount
FROM Sales_Transactions
WHERE Quantity >= 3;


Problem 12

SELECT 
    SKU_Code, 
    Weight
FROM Products
WHERE (Weight * 1000) BETWEEN 200 AND 400;


Problem 13

SELECT 
    Sale_ID,
    (Quantity * Rate) AS Calculated_Amount,
    Gross_Amount
FROM Sales_Transactions
WHERE (Quantity * Rate) != Gross_Amount;


Problem 14

SELECT 
    SKU_Code,
    Amazon_MRP,
    Flipkart_MRP
FROM Pricing
WHERE (Amazon_MRP LIKE '%.00' OR Amazon_MRP LIKE '%.99')
AND (Flipkart_MRP LIKE '%.00' OR Flipkart_MRP LIKE '%.99');


Problem 15

SELECT 
    Operation_ID, 
    Operation_Type, 
    Quantity
FROM Warehouse_Ops
WHERE Quantity % 3 = 0
AND Operation_Type != 'Storage';