-- Create Customers table
CREATE TABLE Customers ( 
    CustomerID INT AUTO_INCREMENT PRIMARY KEY, 
    Name VARCHAR(100), 
    CreditLimit DECIMAL(10,2) NOT NULL
);

-- Create Orders table
CREATE TABLE Orders (
    OrderID INT AUTO_INCREMENT PRIMARY KEY,
    CustomerID INT NOT NULL, 
    Amount DECIMAL(10,2) NOT NULL, 
    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID)
); 

-- Create Shipments table
CREATE TABLE Shipments ( 
    ShipmentID INT AUTO_INCREMENT PRIMARY KEY, 
    OrderID INT NOT NULL, 
    ShippingCost DECIMAL(10,2),
    FOREIGN KEY (OrderID) REFERENCES Orders(OrderID)
);

-- Insert Customers
INSERT INTO Customers (CustomerID, Name, CreditLimit) VALUES 
(1, 'Alice', 5000.00), 
(2, 'Bob', 3000.50), 
(3, 'Charlie', 7000.75), 
(4, 'Diana', 4500.00), 
(5, 'Ethan', 6000.00), 
(6, 'Fiona', 3500.25), 
(7, 'George', 8000.00), 
(8, 'Hannah', 4000.00); 

-- Insert Orders (removed invalid CustomerID = 9)
INSERT INTO Orders (OrderID, CustomerID, Amount) VALUES
(101, 1, 250.00),
(102, 2, 1250.25),
(103, 1, 300.00),
(104, 3, 500.00),
(105, 5, 100.00),
(106, 6, 750.50),
(107, 7, 900.00);

-- Insert Shipments (removed invalid OrderID = 109)
INSERT INTO Shipments (ShipmentID, OrderID, ShippingCost) VALUES
(1001, 101, 25.00),
(1002, 102, 30.50),
(1003, 104, 20.00),
(1004, 106, 15.00),
(1005, 107, 18.75);

SELECT Customers.Name , Orders.OrderID 
FROM Customers 
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID; 

SELECT Customers.CreditLimit, Orders.Amount 
FROM Customers 
RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID; 

SELECT Orders.OrderID , Customers.Name
FROM Orders 
RIGHT JOIN Customers ON Orders.CustomerID = Customers.CustomerID;