SQLize Online / PHPize Online  /  SQLtest Online

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