CREATE TABLE employees (
  employee_id INTEGER PRIMARY KEY,
  last_name TEXT NOT NULL,
  salary INTEGER NOT NULL,
  department TEXT NOT NULL,
  manager_id INTEGER NOT NULL
);

INSERT INTO employees VALUES (23, 'James', 250000, 'IT',111);
INSERT INTO employees VALUES (21, 'Betty', 400000, 'HR',111);
INSERT INTO employees VALUES (41, 'Esty', 650000, 'Management',156);
INSERT INTO employees VALUES (32, 'Rebecca', 850000, 'IT',111);
INSERT INTO employees VALUES (11, 'August', 1220000, 'Management',156);
INSERT INTO employees VALUES (15, 'Inez', 125000, 'HR',156);

CREATE TABLE manager(manager_id INTEGER);
INSERT INTO manager VALUES(111);
INSERT INTO manager VALUES(156);

SELECT o.manager_id, p.employee_id, p.last_name, p.salary, p.department FROM employees p, manager o
where o.manager_id= p.manager_id
order by o.manager_id ASC;