1. 제출 (스스로 푼 방법)
2. 정답
select max(months * salary), count(months * salary)
from Employee where (months * salary)
= (select max(months * salary) from Employee);
출처:
반응형
'데이터관련공부 > SQL' 카테고리의 다른 글
| [HackerRank] SQL - Type of Triangle (다시 시도할 것!) (0) | 2022.06.16 |
|---|---|
| [HackerRank] SQL - Weather Observation Station 20: 다시 시도해야 함... (0) | 2022.06.01 |
| [HackerRank] SQL - Weather Observation Station 19 (0) | 2022.06.01 |
| [HackerRank] SQL - Weather Observation Station 18 (0) | 2022.05.31 |
| [HackerRank] SQL - New Companies (0) | 2022.05.26 |
