Drew Hengehold DEP DEPT_NAME DEPT_LOC --- --------------- --------------- 100 Accounting New York 200 Research Dallas 300 Sales Chicago 400 Operations Boston 500 Management New York 999 Chocolate Arcata 6 rows selected.