4. Salary Query Optimization

Problem Statement

You want to find the maximum salary of the employees. Write a MySQL query to display the maximum salary of the employees based on the month that they were hired. Schema EMPLOYEE, CREATE TEMPORARY TABLE `EMPLOYEE` ( `EMP_NO` int NOT NULL, `EMP_NAME` varchar(50) DEFAULT NULL, `HIRE_DATE` date DEFAULT NULL, `EMP_SALARY` int DEFAULT NULL, `DEPT_ID` int DEFAULT NULL, PRIMARY KEY (`EMP_NO`) ) ENGINE = InnoDB DEFAULT CHARSET = latin1 Table structure Name Type Description EMP_NO int Column denoting EMP_NO representing employee number EMP_NAME varchar(50) Column denoting EMP_NAME representing employee name HIRE_DATE date Column denoting HIRE_DATE representing date on which employee is hired EMP_SALARY int Column denoting EMP_SALARY representing salary of the employee DEPT_ID int Column denoting DEPT_ID representing the id of the department where the employee works Sample testcase 1 Input EMPLOYEE EMP_NO EMP_NAME HIRE_DATE EMP_SALARY DEPT_ID 101 Ram 2020-10-11 1000 34 102 John 2020-11-11 4500 15