CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    DepartmentID INT
);

INSERT INTO Employees (EmployeeID, FirstName, LastName, DepartmentID)
VALUES
    (1, 'Elvish', 'Chapri', 1),
    (2, 'Puneet', 'Superstar', 2),
    (3, 'Thor', 'Odinson', 3),
    (4, 'Tony', 'Stark', 4);
 	 		CREATE TABLE Departments (
    DepartmentID INT PRIMARY KEY,
    DepartmentName VARCHAR(70)
);

INSERT INTO Departments (DepartmentID, DepartmentName)
VALUES
    (1, 'Sweeper'),
    (2, 'Editor'),
    (3, 'SuperHero');
SELECT Employees.FirstName, Employees.LastName, Departments.DepartmentName
FROM Employees
INNER JOIN Departments ON Employees.DepartmentID = Departments.DepartmentID;