SELECT salary * months, count(*)
FROM employee
GROUP BY salary * months DESC
LIMIT 1;'섭섭의 공부 > SQL' 카테고리의 다른 글
| [LeetCode] Reformat Department Table (0) | 2021.12.01 |
|---|---|
| [HackerRank] Type of Triangle (0) | 2021.12.01 |
| [HackerRank] Weather Observation Station 4 (0) | 2021.12.01 |
| [HackerRank] Population Density Difference (0) | 2021.12.01 |
| [HackerRank] Average Population (0) | 2021.12.01 |