[해커랭크] Top Earners

📢 본 포스팅에 활용되는 기본 문제 및 자료 출처는

       해커랭크 Prepare / https://www.hackerrank.com/dashboard  임을 밝힙니다.

---

■ 문제

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

---

■ 풀이

  문제 요구사항  

모든 근로자를 대상으로 전체 최대 임금 금액(salary x months ) 과     < WHERE절 조건 (집계함수 서브쿼리 사용)

해당 금액을 받는 근로자수를 출력                                                                 < 임금별 근로자수 COUNT 함수 사용

SELECT months*salary as earnings,
COUNT(*)
 FROM Employee
 GROUP BY 1
 HAVING earnings = (SELECT max(months*salary) 
                     FROM Employee)