🤔 문제 분석
1) Query the difference between the maximum and minimum populations in CITY.
💡 풀이
SELECT MAX(POPULATION) - MIN(POPULATION)
FROM CITY'코딩테스트 > 해커랭크 SQL' 카테고리의 다른 글
| [해커랭크/SQL] 29. Top Earners (0) | 2023.03.08 |
|---|---|
| [해커랭크/SQL] 28. The Blunder - replace 함수 (0) | 2023.03.08 |
| [해커랭크/SQL] 26. Japan Population (0) | 2023.03.07 |
| [해커랭크/SQL] 25. Average Population (0) | 2023.03.07 |
| [해커랭크/SQL] 24. Revising Aggregations - Averages (0) | 2023.03.06 |
댓글