give me the SQL code

1. Create a view EMP_DEPT that contains the employee_id, last_name, and department_id all employees in department id 90 . They have requested that you label the view columns EMPNO, EMPLOYEE NAME, and DEPTNO. For security purposes, do not allow an employee to be reassigned to another department through the view. 2. display the structure and contents of the EMP_DEPT 3. For each department_name Create a view named EMPDEPT that contains the maximum salary minumum salary average salary , sum salary, count of employees and department_name for all employees work in department id 90 you label the view columns maxsal avgsal minsal sumsal countemp and deptname For security purposes, do not allow an employee to be reassigned to another department through the view