CREATE TABLE Projects (
  ProjectID INTEGER,
  Title INTEGER,
  ClientID INTEGER,
  EmployeeID PRIMARY KEY,
  StartDate INTEGER,
  EndDate INTEGER
);

-- insert some values
INSERT INTO Projects VALUES ('1','Develop ecomments website from scratch', '1', '1003', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','WordPress website for our company', '1', '1002', '2021-08-04', '2021-09-18');
INSERT INTO Projects VALUES ('1','Manage our company servers', '2', '1007', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','Hosting accounts is not working', '3', '1009', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','MySQL database from my desktop application', '4', '1010', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','Develop new WordPress plugin for my business we...', '2', 'NULL', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','Migrate web application and database to new server', '2', 'NULL', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','Android Apllication development', '4', '1004', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','Hosting account is not working', '3', '1001', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','MySQL databse from my desktop application', '4', '1008', '2021-08-04', '2021-09-08');
INSERT INTO Projects VALUES ('1','Develop new WordPress plugin for my business we..', '2', 'NULL', '2021-08-04', '2021-09-08');

-- fetch some values
SELECT * FROM Projects