CREATE TABLE EMPLOYEE (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  dept TEXT NOT NULL,
  age int NOT NULL
);

-- insert
INSERT INTO EMPLOYEE VALUES (0001, 'Clark', 'Sales',18);
INSERT INTO EMPLOYEE VALUES (0002, 'Dave', 'Accounting',19);
INSERT INTO EMPLOYEE VALUES (0003, 'Ava', 'Sales',50);


CREATE VIEW CUSTOMERS_VIEW AS
SELECT name,age
FROM EMPLOYEE;

SELECT * FROM CUSTOMERS_VIEW;

UPDATE CUSTOMERS_VIEW
SET AGE = 35
WHERE name = 'Ava';
SELECT * FROM CUSTOMERS_VIEW;
DELETE FROM CUSTOMERS_VIEW
WHERE age = 19;
SELECT * FROM CUSTOMERS_VIEW;
DROP VIEW CUSTOMERS_VIEW;