# Top Earners Solution

Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | Top Earners Solution

Also Visit:ย  The Blunder Solution

#### Problem

We define an employeeโsย total earningsย to be their monthlyย salary x 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ย 2ย space-separated integers.

Input Format

Theย Employeeย table containing employee data for a company is described as follows:

whereย employee_idย is an employeeโs ID number,ย nameย is their name,ย monthsย is the total number of months theyโve been working for the company, andย salaryย is the their monthly salary.

Sample Input

Sample Output

`69952 1`

Explanation

The table and earnings data is depicted in the following diagram:

The maximumย earningsย value isย 69952. The only employee withย earnings=69952ย ย isย Kimberly, so we print the maximumย earningsย value (69952) and a count of the number of employees who have earnedย \$69952ย (which isย 1) as two space-separated values.

## Solution โ Top Earners

##### MySQL Code
```select max(months * salary),
count(months * salary) from Employee where (months * salary)
= (select max(months * salary) from Employee);```

Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.