Write a query to display the employee number, first name, last name, and largest salary amount for each employee in department 200. Sort the output by largest salary in descending order, and then by employee number (Partial results shown in Figure P7.40).

 

EMP_NUM 83509 83705 83537 EMP_FNAME FRANKLYN JOSE CLEO EMP_LNAME STOVER BARR LARGESTSALARY 210000.00 147000.00 ENGLISH 136000.00 83565 LOURDES ABERNATHY 133000.00 83593 ROSANNE NASH 129000.00 83621 FONDA GONZALEZ 126000.00 83649 DELMA JACOB 123000.00 83677 HERB MANNING 120000.00 83936 BRADFORD BRAY 117000.00 83734 INEZ ROCHA 112000.00