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;