$($A$)$

$($B$)$

$($C$)$

$($D$)$

The following query reports the highest salary amount of all employees by year and job code. Complete the missing values.

SELECT Date.Year, $\_\_\_($A$)\_\_\_,$ MAX$(\_\_\_($B$)\_\_\_)$ FROM Date, Job, Date StartDate, Date EndDate, EmployeeFact WHERE Job.JobID $=$ EmployeeFact.JobID AND StartDate.DateID $=$ EmployeeFact.StartDateID AND EndDate.DateID $=$ EmployeeFact.EndDateID AND $\_\_\_($C$)\_\_\_$ BETWEEN StartDate.Year AND EndDate.Year GROUP BY $\_\_\_($D$)\_\_\_$;

SELECT Date.Year, blank$1,$ MAX$($blank$2)$ FROM FROM Date, Job, Date StartDate, Date EndDate, EmployeeFact WHERE Job.JobID $=$ EmployeeFact.JobID AND StartDate.DateID $=$ EmployeeFact.StartDateID AND EndDate.DateID $=$ EmployeeFact.EndDateID AND blank$3$ BE