CREATE TABLE EMPLOYEE (
empId int PRIMARY KEY,
name text,
dept text
);
INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0001, 'Clark', 'Sales');
INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0002, 'Dave', 'Accounting');
INSERT INTO EMPLOYEE(empId,name,dept) VALUES (0003, 'Ava', 'Sales');
SELECT * FROM EMPLOYEE;