Using your EMPLOYEES$\_$VU view, write a query for the HR department to display all

$$employee names and department numbers$4.$Department $80$ needs access to its employee data. Create a view named dept$80$ that contains the

employee numbers, employee last names, and department numbers for all employees in department

$80.$

You have been asked to label the view columns EMPNO,EMPLOYEE, and DEPTNO.

For security purposes, do not allow an employee to be reassigned to another department through

the view.