【单选题】
Examine the data of the EMPLOYEES table.<br /> EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)<br /> EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY<br /> EMPLOYEE_ID<br /> 101 Smith 20 120 SA_REP 4000<br /> 102 Martin 10 105 CLERK 2500<br /> 103 Chris 20 120 IT_ADMIN 4200<br /> 104 John 30 108 HR_CLERK 2500<br /> 105 Diana 30 108 HR_MGR 5000<br /> 106 Bryan 40 110 AD_ASST 3000<br /> 108 Jennifer 30 110 HR_DIR 6500<br /> 110 Bob 40 EX_DIR 8000<br /> 120 Ravi 20 110 SA_DIR 6500<br /> Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）
A、SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000;
B、SELECT e.employee_id "Emp_id", e.emp_name "Employee",
C、salary,
D、employee_id "Mgr_id", m.emp_name "Manager" FROM employees e, employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;
查看正确答案
