PLSQL笔试问题

各位大侠，麻烦看下这道题，答案B好像不对，帮忙确认下
QUESTION NO: 32
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS
tables.

EMPLOYEES
EMPLOYEE_ID        NUMBER  NOT NULL, Primary Key
EMP_NAME  VARCHAR2 (30)   
JOB_ID  VARCHAR2 (20)   
SALARY  NUMBER   
MGR_ID  NUMBER  References EMPLOYEE_ID column
DEPARTMENT_ID  NUMBER  Foreign key to DEPARTMENT_ID column of the
DEPARTMENTS table
DEPARTMENTS
DEPARTMENT_ID          NUMBER  NOT NULL, Primary Key
DEPARTMENT_NAME  VARCHAR2
(30)

MGR_ID  NUMBER  References NGR_ID column of the
EMPLOYEES table  
LOCATION_ID  NUMBER  Foreign key to LOCATION_ID column of the
LOCATIONS table

LOCATIONS
LOCATION_ID  NUMBER  NOT NULL, Primary Key
CITY  VARCHAR2 |30)   

Which two SQL statements produce the name, department name, and the city of all the
employees who earn more then 10000? (Choose two)

A.  SELECT emp_name, department_name, city
FROM      employees e
JOIN         departments d
USING      (department_id)
JOIN         locations 1
USING      (location_id)
WHERE    salary > 10000;
B.  SELECT emp_name, department_name, city
FROM    employees e, departments d, locations 1
JOIN ON  (e.department_id = d.department id)
AND       (d.location_id =1.location_id)
AND       salary > 10000;
C.          SELECT emp_name, department_name, city
FROM    employees e, departments d, locations 1
WHERE salary > 10000;
D.  SELECT emp_name, department_name, city
FROM    employees e, departments d, locations 1
WHERE e.department_id = d.department_id
AND       d.location_id = 1.location_id
AND       salary > 10000;
E.          SELECT emp_name, department_name, city
FROM    employees e
NATURAL JOIN departments, locations
WHERE salary > 10000;


Answer: B, D