Расширенные возможности SQL. Команды SQL в рамках урока #9

-- View Table (Представления таблиц в SQL)
-- https://youtu.be/tm5mKMaV9XE

-------------------------------------------
-- Расширенные возможности SQL. Примеры команд SQL в рамках урока #9.


SELECT * FROM EMP_DETAILS_VIEW;


SELECT * FROM EMPLOYEES;


CREATE VIEW KMV_EMPLOYEE AS
SELECT a.EMPLOYEE_ID, a.FIRST_NAME, a.LAST_NAME, b.DEPARTMENT_NAME, a.SALARY
FROM
   EMPLOYEES a
   LEFT JOIN DEPARTMENTS b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
WHERE
   a.EMPLOYEE_ID >= 150
   AND b.DEPARTMENT_NAME IS NOT NULL
   AND b.DEPARTMENT_NAME NOT IN ('Shipping', 'Sales')
;


CREATE OR REPLACE VIEW KMV_EMPLOYEE AS
SELECT a.EMPLOYEE_ID, a.FIRST_NAME, a.LAST_NAME, b.DEPARTMENT_NAME, a.SALARY
FROM
   EMPLOYEES a
   LEFT JOIN DEPARTMENTS b ON a.DEPARTMENT_ID = b.DEPARTMENT_ID
WHERE
   a.EMPLOYEE_ID >= 150
   AND b.DEPARTMENT_NAME IS NOT NULL
   AND b.DEPARTMENT_NAME NOT IN ('Shipping', 'Sales')
   AND SALARY > 8000
;


SELECT * FROM KMV_EMPLOYEE;


SELECT * FROM KMV_EMPLOYEE
WHERE EMPLOYEE_ID = 204
;


DROP VIEW KMV_EMPLOYEE;