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;