[HackerRank/SQL] Revising Aggregations - Top Earners

Problem. Revising Aggregations - Top Earners

---

Link.

https://www.hackerrank.com/challenges/earnings-of-employees/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=24-hour-campaign

The Blunder | HackerRank

---

Description.

We define an employee's total earnings to be their monthly  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.

 

 

Employee 테이블

Employee 테이블 예시

---

Key Point. 

SELECT,

 

MAX,

 

COUNT,

 

IF,

 

 

Comments:

aiengr_talha님과 유사하게

SELECT
  MAX(SALARY * MONTHS),
  COUNT(IF(SALARY * MONTHS = MAX(SALARY * MONTHS), 1, null))
FROM Employee;

를 사용하려고 했음 (실제로 시도했지만, 원하는 데이터를 얻어올 수 없었음ㅠ)

• pyata_sandeep님의 답변을 참고하여 쿼리를 재작성함

---

My Answer. 

SELECT
    MAX(SALARY * MONTHS),
    COUNT(IF(SALARY * MONTHS = (SELECT MAX(SALARY * MONTHS) FROM Employee), 1, null))
FROM Employee;

---

References.