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