create or replace view dept50

as

select employee_id empno, last_name employee, department_id deptno

from employees

where department_id = 50

with check option constraint emp_dept_50;

10.

Display the structure and contents of the DEPT50 view.