Find MAX & MIN Salary 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. 
 
Ebook Download
View all
Learn
View all