CREATE TABLE Employee(
       ssNo TEXT PRIMARY KEY,
       name TEXT,
       vacancy TEXT, 
       salary REAL
);


INSERT INTO Employee
VALUES('300494-113C', 'Teemu Teekkari', 'programmer', 2500.0),
('240691-338V', 'Nina Teekkari', 'the boss', 6800.0),
('110593-226F', 'Riina Raksalainen', 'consultant', 4250.0),
('270483-510F', 'Ben Bittinikkari', 'full stack developer', 6750.0);

