Write a query to display the current salary for each employee in department 300. Assume that only current employees are kept in the system, and therefore the most current salary for each employee is the entry in the salary history with a NULL end date. Sort the output in descending order by salary amount (Figure P7.48).

Transcribed Image Text:

Figure P7.48 Current Salary for Employees in Department 300 Emp_Num Emp_LName Emp_FName Sal_Amount 83746 RANKIN 84328 CARPENTER 83716 RIVERA 84432 JAMISON 83902 VARGAS 83695 MENDEZ 84500 WESTON 84594 TIDWELL 83910 AVERY 83359 WATTS 83790 ACEVEDO SEAN FERN HENRY MERLE ROCKY CARROLL CHRISTINE ODELL LAUREN MERLE LAVINA 95550 94090 85920 85360 79540 79200 78690 77400 76110 72240 72000