CREATE TABLE Orders (
    OrderID int,
    CustomerID int,
    OrderDate date,
    OrderTotal decimal
);

CREATE TABLE Customers (
    CustomerID int,
    CustomerName varchar(50),
    CustomerEmail varchar(50),
    CustomerCountry varchar(50)
);

INSERT INTO Customers (CustomerID, CustomerName, CustomerEmail, CustomerCountry)
VALUES (1, 'Max Maxbetov', 'max.betov@example.com', 'Russian'),
       (2, 'Jane Smith', 'jane.smith@example.com', 'Canada'),
       (3, 'Alice Johnson', 'alice.johnson@example.com', 'UK');

INSERT INTO Orders (OrderID, CustomerID, OrderDate, OrderTotal)
VALUES (1, 1, '2024-01-01', 100.00),
       (2, 2, '2024-02-04', 150.00),
       (3, 1, '2023-05-04', 120.00),
       (4, 3, '2024-07-04', 80.00);

-- Inner Join
SELECT Orders.Name , Customers.CustomerName FROM Orders
INNER JOIN Customers
ON Orders.CustomerID = Customers.CustomerID;

-- Inner Join
SELECT Orders.Name , Customers.CustomerName, Customers.CustomerEmail FROM Orders
INNER JOIN Customers
ON Orders.CustomerID = Customers.CustomerID;

-- Left Join
SELECT Orders.Name , Customers.CustomerName FROM Orders
LEFT JOIN Customers
ON Orders.CustomerID = Customers.CustomerID;

-- Right Join
SELECT Customers.Name , Orders.OrderID, Orders.OrderDate, Orders.OrderTotal FROM Customers
RIGHT JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;