SQL Practice Problems - Day 2
Focus: Arithmetic, Comparison & Logical Operators

1 - Calculate total inventory value (stock × TP price) for products with <100 units in stock.
Input Tables: Inventory, Pricing
Output: SKU_Code, Inventory_Value

2 - List products where Final_MRP exceeds TP_Price by exactly 50%.
Input Table: Pricing
Output: SKU_Code, TP_Price, Final_MRP

3 - Find sales transactions with quantities between 3-5 or amounts over ₹2000.
Input Table: Sales_Transactions
Output: Sale_ID, Quantity, Gross_Amount

4 - Identify products in 'Men' category weighing ≥0.3kg but not priced at ₹2295.
Input Tables: Products, Pricing
Output: SKU_Code, Weight, Final_MRP

5 - Show warehouse operations processing exactly 1, 3, or 5 items.
Input Table: Warehouse_Ops
Output: Operation_ID, Operation_Type, Quantity

6 - Calculate price difference percentage between Amazon and Flipkart MRPs.
Input Table: Pricing
Output: SKU_Code, Price_Diff_Percentage

7 - Find products where TP_Price is odd-valued and category isn't 'Kids'.
Input Tables: Products, Pricing
Output: SKU_Code, TP_Price, Category

8 - List sales where rate/item is <80% of TP_Price or >120% of TP_Price.
Input Tables: Sales_Transactions, Pricing
Output: Sale_ID, Rate, TP_Price

9 - Identify products with stock levels 10-20% above/below average stock.
Input Tables: Inventory
Output: SKU_Code, Stock_Qty, Avg_Stock

10 - Find customers who purchased in Q3 2021 with amounts ≠ ₹500, ₹1000, or ₹1500.
Input Tables: Sales_Transactions, Customers
Output: Customer_ID, Gross_Amount

11 - Calculate net sales after 10% discount on orders with 3+ items.
Input Table: Sales_Transactions
Output: Sale_ID, Gross_Amount, Net_Amount

12 - List products where weight (kg) × 1000 is between 200-400 grams.
Input Table: Products
Output: SKU_Code, Weight

13 - Find transactions where (quantity × rate) doesn't match gross amount.
Input Table: Sales_Transactions
Output: Sale_ID, Calculated_Amount, Gross_Amount

14 - Identify products with MRPs ending in .00 or .99 across all platforms.
Input Table: Pricing
Output: SKU_Code, Amazon_MRP, Flipkart_MRP

15 - Show operations where (quantity mod 3) = 0 and type isn't Storage.
Input Table: Warehouse_Ops
Output: Operation_ID, Operation_Type, Quantity