Untitled

CREATE VIEW EmployeeDetailsInDelhi AS SELECT e.employee_id, CONCAT(e.first_name,", e.last_name) AS employee_name, e.phone_number, j.job d.department_name, CONCAT(m.first_name,", m.last name) AS manager_name FROM employees e JOIN departments d ON e.department id=d.department id JOIN jobs ) ON iob id=j.job_id LEFT JOIN employees m ON e.manager id= m.employee_id JOIN locations 1ON d.location_id =1.location_id WHERE I.city = 'Delhi:a