Write a query to display the starting salary for each employee. The starting salary would be the entry in the salary history with the oldest salary start date for each employee. Sort the output by employee number (Figure P7.49).

Transcribed Image Text:

Figure P7.49 Starting Salary for Each Employee Emp_ Num Emp_LName Emp_FName Sal_Amount 83304 MCDONALD TAMARA CONNIE ROSALBA CHAROLETTE DARCIE ANGELINA WILLARD CHRISTINE QUINTIN JENNIFFER MERLE PHOEBE 83308 LOVE 83312 BAKER 83314 DAVID 83318 PECK 83321 FARMER 83332 LONG 83341 CORTEZ 83347 WINN 83349 SINGH 83359 WATTS 83366 BLEDSOE 19770 11230 39260 15150 22330 18250 23380 14510 17010 21220 25370 23200