Hacker Rank SQL

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:

Column Type
employee_id Integer
name String
months Integer
salary Integer

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

employee_id name months salary
12228 Rose 15 1968
33645 Angela 1 3443
45692 Frank 17 1608
56118 Patrick 7 1345
59725 Lisa 11 2330
74197 Kimberly 16 4372
78454 Bonnie 8 1771
83565 Michael 6 2017
98607 Todd 5 3396
99989 Joe 9 3573

Sample Output

69952 1

Explanation

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

employee_id name months salary earnings
12228 Rose 15 1968 29520
33645 Angela 1 3443 3443
45692 Frank 17 1608 27336
56118 Patrick 7 1345 9415
59725 Lisa 11 2330 25630
74197 Kimberly 16 4372 69952
78454 Bonnie 8 1771 14168
83565 Michael 6 2017 12102
98607 Todd 5 3396 16980
99989 Joe 9 3573 32157

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.