CREATE DATABASE New_Database;

/* Creating Tables */

CREATE TABLE Employee(
EmployeeID int,
EmployeeFirstName varchar(20),
EmployeeLastName varchar(20),
PRIMARY KEY (EmployeeID)
);

INSERT INTO Employee
       VALUES  (155, 'Dianne', 'Lux'),
               (283, 'Matt', 'Loe'),
               (152, 'Anthony', 'Lee'),
               (362, 'Lindsay', 'Moen'),
               (421, 'Mable', 'Fan');


Select * from Employee

CREATE TABLE Tool(
ToolID int,
Date_of_Last_Inspection varchar(100),
Status_of_tool varchar(20) ,
Tool_Name varchar(20),
PRIMARY KEY (ToolID)
);


INSERT INTO Tool
       VALUES  (155, '2017-07-18','Checked_out', 'Plunger'),
               (283, '2019-02-13', 'in_storage', 'Screwdriver'),
               (152, '2018-06-12', 'Checked_out', 'Nail_Gun'),
               (362, '2017-01-03', 'in_storage', 'Pliers');

SELECT * FROM Tool

--- INNER JOIN
select * from Tool T
INNER JOIN Employee E
ON t.EmployeeID =e.EmployeeID;

--- FULL JOINS
select * from Tool t
FULL JOIN Employee E
ON t.EmployeeID = e.EmployeeID;

--- left outer join
select * from Tool t
LEFT OUTER JOIN Employee E
ON e.EmployeeID=t.EmployeeID;

---Right outer join
select * from Tool t
RIGHT OUTER JOIN Employee E
ON e.EmployeeID=t.EmployeeID;

--- Intersect
Select * from Tool
Intersect
Select * Employee

---Union
Select * from Tool
Union
Select * from Employee

--- Except
Select * from Tool
Except
Select * from Employee