INSERT INTO Student (knowledge) VALUES ('SQL')

createdb CompanyDatabase

pgcli CompanyDatabase

CREATE TABLE Employees (Id INT, FullName TEXT, Salary INT, Department TEXT, PhoneExtension INT, IsPartTime BOOLEAN);

SELECT * FROM employees

SELECT fullname, phoneextension FROM employees WHERE isparttime = false;

INSERT INTO employees (id, fullname, salary, department, phoneextension, isparttime) VALUES (8, 'Gorgeous George', 450, 'software developer', 108, true);

UPDATE employees SET salary=500 WHERE department = 'cook';

DELETE FROM employees WHERE fullname = 'Lazy Lynn';

UPDATE employees SET isparttime=false;

ALTER TABLE employees ADD ParkingSpotNumber VARCHAR(10);