|
1
2
3
4
|
select salary*months as earnings , count(employee_id)
from employee
group by earnings desc
limit 1
|
cs |
반응형
'SQL' 카테고리의 다른 글
| Hacker rank Weather Observation Station 13 (0) | 2021.10.21 |
|---|---|
| Hacker rank Weather Observation Station 2 (0) | 2021.10.21 |
| Hacker rank The Blunder (0) | 2021.10.21 |
| Hacker rank Population Density Difference (0) | 2021.10.21 |
| Hacker rank Japan Population (0) | 2021.10.21 |
댓글