Write a query to display the department number, department name, department phone number, employee number, and last name of each department manager. Sort the output by departmentname.

Transcribed Image Text:

DEPT NUMİ | DEPT PHONE! EMP NUM! EMP LNAME 555-2333 DEPT NAME 600 ACCOUNTING 250 CUSTOMER SERVICE 555-5555 500 DISTRIBUTION 280 MARKETING 300 PURCHASING 200 SALES 550 TRUCKING 400 WAREHOUSE555-1003 555-3624 555-8500 555-4873 555-2824 555-0057 84583 YAZZIE 84001 FARMER 84052 FORD 84042 PETTIT 83746 RANKIN 83509 STOVER 83683 STONE 83759 CHARLES