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, 'Timur Onewinov', 'timur.1win@example.com', 'Russian'),
       (3, 'Daniel Stoyakovski', 'dan.stoyak@example.com', 'Russian');

INSERT INTO Orders (OrderID, CustomerID, OrderDate, OrderTotal)
VALUES (1, 1, '2024-01-01', 2500.00),
       (2, 2, '2024-02-04', 250.00),
       (3, 1, '2023-05-04', 111.00),
       (4, 3, '2024-07-04', 650.00);

SELECT Orders.OrderID, Orders.CustomerID, Orders.OrderDate, Orders.OrderTotal, Customers.CustomerName
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

SELECT Orders.OrderID, Orders.CustomerID, Orders.OrderDate, Orders.OrderTotal, Customers.CustomerName, Customers.CustomerEmail
FROM Orders
INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

SELECT Orders.OrderID, Orders.CustomerID, Orders.OrderDate, Customers.CustomerName
FROM Orders
LEFT JOIN Customers ON Orders.CustomerID = Customers.CustomerID;


SELECT Customers.CustomerName, Orders.OrderID, Orders.OrderDate, Orders.OrderTotal
FROM Customers
RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID;