CREATE TABLE employees (
  id INTEGER PRIMARY KEY,
  last_name TEXT NOT NULL,
  name TEXT NOT NULL,
  job TEXT NOT NULL
);

INSERT INTO employees VALUES (111, 'McNulty', 'Jimmy', 'manager');
INSERT INTO employees VALUES (222, 'Greggs', 'Kima', 'officer');
INSERT INTO employees VALUES (333, 'Moreland', 'Bunk', 'detective');
INSERT INTO employees VALUES (444, 'Colvin', 'Bunny', 'HR');
INSERT INTO EMPLOYEES VALUES (555, 'Pryzbylewski', 'Roland', 'The teacher');

SELECT last_name,job FROM employees WHERE job!='manager';