如何在Oracle SQL中创建包含三个表的视图？

CREATE TABLE employees (
    employee_id NUMBER,
    first_name VARCHAR2(50),
    last_name VARCHAR2(50),
    department_id NUMBER
);

CREATE TABLE departments (
    department_id NUMBER,
    department_name VARCHAR2(50),
    location_id NUMBER
);

CREATE TABLE locations (
    location_id NUMBER,
    city VARCHAR2(50),
    state_province VARCHAR2(50),
    country_id CHAR(2)
);

CREATE OR REPLACE VIEW employee_department_location AS
SELECT 
    e.employee_id,
    e.first_name,
    e.last_name,
    d.department_name,
    l.city,
    l.state_province,
    l.country_id
FROM 
    employees e
JOIN 
    departments d ON e.department_id = d.department_id
JOIN 
    locations l ON d.location_id = l.location_id;