SQL Practice Problems - Day 4
Focus: Table Joins (INNER, LEFT, Multi-table)

1 - List products with their current inventory quantities.
Input Tables: Products, Inventory
Output: SKU_Code, Design_No, Stock_Qty

2 - Show all customers and any sales they've made (include customers with no sales).
Input Tables: Customers, Sales_Transactions
Output: Customer_ID, Customer_Name, Sale_ID

3 - Find products that have never been sold.
Input Tables: Products, Sales_Transactions
Output: SKU_Code, Design_No

4 - Display sales transactions with complete product details.
Input Tables: Sales_Transactions, Products
Output: Sale_ID, SKU_Code, Design_No, Category, Quantity

5 - List warehouse operations with product category information.
Input Tables: Warehouse_Ops, Products
Output: Operation_ID, SKU_Code, Category, Operation_Type

6 - Show all products and their platform prices (include products with no pricing).
Input Tables: Products, Pricing
Output: SKU_Code, Design_No, Amazon_MRP, Flipkart_MRP

7 - Find customers who purchased products weighing more than 0.3kg.
Input Tables: Customers, Sales_Transactions, Products
Output: Customer_ID, Customer_Name, SKU_Code, Weight

8 - Identify sales transactions where the rate was below TP price.
Input Tables: Sales_Transactions, Pricing
Output: Sale_ID, SKU_Code, Rate, TP_Price

9 - List all products with their total sales quantity (include products with no sales).
Input Tables: Products, Sales_Transactions
Output: SKU_Code, Design_No, Total_Sold

10 - Show customers along with their most purchased product category.
Input Tables: Customers, Sales_Transactions, Products
Output: Customer_ID, Customer_Name, Top_Category

11 - Find products that exist in inventory but have no pricing information.
Input Tables: Inventory, Pricing
Output: SKU_Code, Stock_Qty

12 - Display all warehouse operations with product and pricing details.
Input Tables: Warehouse_Ops, Products, Pricing
Output: Operation_ID, SKU_Code, Design_No, TP_Price, Operation_Type

13 - Identify customers who purchased from exactly 2 different product categories.
Input Tables: Customers, Sales_Transactions, Products
Output: Customer_ID, Customer_Name, Category_Count

14 - Show products with inconsistent pricing across platforms (differ by >10%).
Input Tables: Products, Pricing
Output: SKU_Code, Design_No, Amazon_MRP, Flipkart_MRP, Price_Difference

15 - List all products with their total sales value and inventory value.
Input Tables: Products, Sales_Transactions, Inventory, Pricing
Output: SKU_Code, Design_No, Total_Sales_Value, Inventory_Value