SQL Practice Problems - Day 5
Focus: Advanced Joins (RIGHT, FULL OUTER, Self Joins)

1 - List all pricing records with product details (include pricing entries without products).
Input Tables: Pricing, Products
Output: SKU_Code, Design_No, TP_Price, Final_MRP

2 - Show all warehouse operations and matching products (include operations without products).
Input Tables: Warehouse_Ops, Products
Output: Operation_ID, SKU_Code, Design_No, Operation_Type

3 - Find products that exist in either inventory or pricing but not in both.
Input Tables: Inventory, Pricing
Output: SKU_Code

4 - Display all customers and all products (Cartesian product).
Input Tables: Customers, Products
Output: Customer_ID, Customer_Name, SKU_Code, Design_No

5 - List products with their parent category (self join on category hierarchy).
Input Tables: Products
Output: SKU_Code, Category, Parent_Category

6 - Show all inventory records with pricing (include inventory without pricing and pricing without inventory).
Input Tables: Inventory, Pricing
Output: SKU_Code, Stock_Qty, TP_Price

7 - Find customers who purchased the same product multiple times.
Input Tables: Customers, Sales_Transactions
Output: Customer_ID, Customer_Name, SKU_Code, Purchase_Count

8 - Identify products with NULL values in either weight or color fields.
Input Tables: Products
Output: SKU_Code, Weight, Color

9 - List all possible combinations of sizes and colors available.
Input Tables: Products
Output: Size, Color

10 - Show products with their recommended pairings (self join on category).
Input Tables: Products
Output: Product_SKU, Product_Design, Pair_SKU, Pair_Design

11 - Find customers who never purchased certain product categories.
Input Tables: Customers, Sales_Transactions, Products
Output: Customer_ID, Customer_Name, Missing_Categories

12 - Display all products with their sales and inventory status (full picture).
Input Tables: Products, Sales_Transactions, Inventory
Output: SKU_Code, Has_Sales, In_Inventory

13 - Identify products that are always sold in the same quantity.
Input Tables: Sales_Transactions
Output: SKU_Code, Consistent_Quantity

14 - Show hierarchical relationships between product categories.
Input Tables: Products
Output: Category, Parent_Category, Hierarchy_Level

15 - List all possible customer-product pairs with purchase status.
Input Tables: Customers, Products, Sales_Transactions
Output: Customer_ID, SKU_Code, Has_Purchased