Exploring Maximum Earnings & Employee Achievements IN SQL | COUNT | ORDER | GROUP BY | DESC | TOP
Exploring Maximum Earnings & Employee Achievements IN SQL | COUNT | ORDER | GROUP BY | DESC | TOP
USE OF ORDER BY
USE OF MIN
USE OF MAX
USE OF COUNT
USE OF SUM
USE OF ORDER BY
USE OF GROUP BY
USE OF SELECT COMMAND
USE OF TOP
USE OF SQL
QUESTION:We define an employee’s total earnings to be their monthly salary* months worked, and the maximum total earnings to be the maximum total earnings for any employee in the Employee table. Write a query to find the maximum total earnings for all employees as well as the total number of employees who have maximum total earnings. Then print these values as space-separated integers.