2. Find the minimum, maximum and average salary of each employee title and order the results by ascending order of maximum salary SELECT J.JOB _TITLE,J.MIN _SALARY,J.MAX_SALARY,AVG(E.SALARY) FROM jobs JFULL OUTER JOIN employees E on J.JOB_ID = E.JOB_IDORDER BY J.MAX_SALARY

2. Find the minimum, maximum and average salary of each employee title and order the results by ascending order of maximum salary 

SELECT J.JOB _TITLE,

J.MIN _SALARY,

J.MAX_SALARY,

AVG(E.SALARY) 

FROM jobs J

FULL OUTER JOIN employees E on 

J.JOB_ID = E.JOB_ID

ORDER BY J.MAX_SALARY