CREATE TABLE employees (
  emp_id INTEGER PRIMARY KEY,
  last_name TEXT NOT NULL,
  salary INTEGER NOT NULL
);

INSERT INTO employees VALUES (14, 'Heick', 200000);
INSERT INTO employees VALUES (23, 'Ven', 3500000);
INSERT INTO employees VALUES (7, 'Gin', 500000);
INSERT INTO employees VALUES (53, 'Grant', 2500000);
INSERT INTO employees VALUES (31, 'Epse', 7500000);

SELECT emp_id, last_name, salary, salary+(salary*15.5/100) "New Salary" from employees;