From the employee table, calculate the average compensation for each job category where the employee has 16 or more years of education. Display the job and average compensation in the result set....

From the employee table, calculate the average compensation for each job category where the employee has 16 or more years of education. Display the job and average compensation in the result set. Exclude people who are clerks Make sure to include salary, commission and bonus when looking at employee compensation Order the output by the average salary in ascending order