create schema seminar_2;
CREATE TABLE seminar_2.salary(
employee_nm TEXT,
department_nm TEXT,
salary INT
);
INSERT INTO seminar_2.salary (employee_nm, department_nm, salary) VALUES ('Ivan', 'FIVT', 2000000);
INSERT INTO seminar_2.salary (employee_nm, department_nm, salary) VALUES ('Natalia', 'FOPF', 5000000);
INSERT INTO seminar_2.salary (employee_nm, department_nm, salary) VALUES ('Sergey', 'FIVT', 4000000);
INSERT INTO seminar_2.salary (employee_nm, department_nm, salary) VALUES ('Pyotr', 'FBMF', 30000);
INSERT INTO seminar_2.salary (employee_nm, department_nm, salary) VALUES ('Alexey', 'FOPF', 200000);
ALTER TABLE seminar_2.salary
ADD comment TEXT;
UPDATE seminar_2.salary
SET comment = (CASE
WHEN employee_nm = 'Ivan'
THEN 'He is very clever!'
WHEN employee_nm = 'Natalia'
THEN 'She is nice!'
WHEN employee_nm = 'Sergey'
THEN 'He is mean to others!'
WHEN employee_nm = 'Pyotr'
THEN 'He did not finish his degree'
WHEN employee_nm = 'Alexey'
THEN 'Shtannikov'
END);
ALTER TABLE seminar_2.salary
DROP COLUMN comment;
DELETE FROM seminar_2.salary WHERE employee_nm='Sergey';
TRUNCATE TABLE seminar_2.salary;
INSERT INTO seminar_2.salary VALUES('Ken Sánchez', 'HR', 78);
INSERT INTO seminar_2.salary VALUES('TerriLee Duffy', 'HR', 95);
INSERT INTO seminar_2.salary VALUES('Roberto Tamburello', 'HR', 382);
INSERT INTO seminar_2.salary VALUES('Rob Walters', 'HR', 16);
INSERT INTO seminar_2.salary VALUES('Gail Erickson', 'HR', 1079);
INSERT INTO seminar_2.salary VALUES('Jossef Gibson', 'HR', 102);
INSERT INTO seminar_2.salary VALUES('Dylan Miller', 'HR', 486);
INSERT INTO seminar_2.salary VALUES('Diane Margheim', 'HR', 1953);
INSERT INTO seminar_2.salary VALUES('Gigi Matthew', 'SALE', 49);
INSERT INTO seminar_2.salary VALUES('Michael Raheem', 'SALE', 71);
INSERT INTO seminar_2.salary VALUES('Ovidiu Cracium', 'SALE', 94);
INSERT INTO seminar_2.salary VALUES('Thierry Hers', 'SALE', 61);
INSERT INTO seminar_2.salary VALUES('Janice Galvin', 'SALE', 972);
INSERT INTO seminar_2.salary VALUES('Michael Sullivan', 'SALE', 849);
INSERT INTO seminar_2.salary VALUES('Sharon Salavaria', 'SALE', 71);
SELECT *
FROM seminar_2.salary
WHERE (salary > 100) AND (employee_nm LIKE '%a% %');
SELECT *
FROM seminar_2.salary
Telegram: DB developers channel