CREATE TABLE EMPLOYEE (
empId INTEGER PRIMARY
KEY, name TEXT NOT NULL,
dept TEXT NOT NULL
);
-- insert
INSERT INTO EMPLOYEE VALUES (0001, 'Clark', 'Sales');
INSERT INTO EMPLOYEE VALUES (0002, 'Dave', 'Accaunting');
INSERT INTO EMPLOYEE VALUES (0003, 'Ava', 'Sales');
-- fetch
SELECT * FROM EMPLOYEE WHERE dept = ' ';
Q1JFQVRFIFRBQkxFIEVNUExPWUVFICgKICBlbXBJZCBJTlRFR0VSIFBSSU1BUlkgS0VZLAogIG5hbWUgVEVYVCBOT1QgTlVMTCwKICBkZXB0IFRFWFQgTk9UIE5VTEwKKTsKCi0tIGluc2VydApJTlNFUlQgSU5UTyBFTVBMT1lFRSBWQUxVRVMgKDAwMDEsICdDbGFyaycsICdTYWxlcycpOwpJTlNFUlQgSU5UTyBFTVBMT1lFRSBWQUxVRVMgKDAwMDIsICdEYXZlJywgJ0FjY2F1bnRpbmcnKTsKSU5TRVJUIElOVE8gRU1QTE9ZRUUgVkFMVUVTICgwMDAzLCAnQXZhJywgJ1NhbGVzJyk7CgotLSBmZXRjaCAKU0VMRUNUICogRlJPTSBFTVBMT1lFRSBXSEVSRSBkZXB0ID0gJyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAnOwoK
CREATE TABLE EMPLOYEE (
empId INTEGER PRIMARY KEY,
name TEXT NOT NULL,
dept TEXT NOT NULL
);
-- insert
INSERT INTO EMPLOYEE VALUES (0001, 'Clark', 'Sales');
INSERT INTO EMPLOYEE VALUES (0002, 'Dave', 'Accaunting');
INSERT INTO EMPLOYEE VALUES (0003, 'Ava', 'Sales');
-- fetch
SELECT * FROM EMPLOYEE WHERE dept = ' ';