https://www.hackerrank.com/challenges/earnings-of-employees/problem

📔문제

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 2 space-separated integers.

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.

---

📝예시

69952 1

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.

---

🧮분야

• AGGREGATION

---

📃SQL 코드

select salary*months, count(*)
from employee
where salary*months=(select max(salary*months)
                    from employee)
group by salary*months;

---

📰출력 결과

---

📂고찰

첫번째는 max(salary*months)를 출력하고 두번째는 그 max값을 가지는 사람의 수를 count하면 된다!