单项选择题
A.CREATE VIEW emp_vu AS SELECT employee_id，emp_name，department_id FROM employees WHERE mgr_id IN （102，120）；
B.CREATE VIEW emp_vu AS SELECT employee_id，emp_name，job_id，department_id FROM employees WHERE mgr_id IN （102，120）；
C.CREATE VIEW emp_vu AS SELECT department_id，SUM（sal）TOTALSAL FROM employees WHERE mgr_id IN （102，120）GROUP BY department_id；
D.CREATE VIEW emp_vu AS SELECT employee_id，emp_name，job_id，DISTINCT department_id FROM employees；
