IS IT POSSIBLE TO RETRIEVE NUMBER OF DEPARTMENTS AND THE NUMBER OF EMPLOYEES WORKING IN THAT DEPARTMENT IF GIVEN THE LOCATION ID : IS IT POSSIBLE TO RETRIEVE NUMBER OF DEPARTMENTS AND THE NUMBER OF EMPLOYEES WORKING IN THAT DEPARTMENT IF GIVEN THE LOCATION ID

CANNOT GET THE CORRECT RESULT WITH THIS QUERY:
select count(E.employee_id),COUNT(D.DEPARTMENT_ID)from employees e   join departments d on (e.department_id=d.department_id) WHERE D.LOCATION_ID =1700;

ANY HELP WILL BE APPRECIATED, THANKS