Find MAX & MIN Salary By Year

How we can find MAX & MIN salary in a Table Group By Year.

Below is My Table:

 

 

 

Image 1.

 

 

 Now Query Is:

 

SELECT YEAR, MAX(AMOUNT) AS MAXSALARY,
           MIN(AMOUNT) AS MINSALARY
FROM EMPLOYEE_SALARY
GROUP BY YEAR

Image 2.