To create the MORT table, use the following code:

sqlite> CREATE TABLE MORT(
  Pid VARCHAR(30) NOT NULL,
  Mortality_date DATE NOT NULL,
  PRIMARY KEY (Pid)
);

sqlite> INSERT INTO MORT (Pid, Mortality_date)
VALUES ('1', '2016-05-15');

sqlite> INSERT INTO MORT (Pid, Mortality_date)
VALUES ('4', '2016-06-08');