일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 |
Tags
- Numpy
- affine
- sort
- select
- que
- 자연어처리
- kakao
- DeepLearning
- FullyConnectedLayer
- 프로그래머스
- SQL
- dl
- Programmers
- algorithm
- stak
- Sigmoid
- Python
- backward
- 신경망
- boj
- skip-gram
- 파이썬
- 딥러닝
- Word2vec
- Stack
- Heap
- hash
- MySQL
- PPMI
- CBOW
Archives
- Today
- Total
혜온의 이것저것
[HackerRank] Population Density Difference (MySQL) 본문
https://www.hackerrank.com/challenges/population-density-difference/problem?isFullScreen=true
Population Density Difference | HackerRank
Query the difference between the maximum and minimum city populations in CITY.
www.hackerrank.com
문제
Query the difference between the maximum and minimum populations in CITY.
Input Format
The CITY table is described as follows:
![](https://blog.kakaocdn.net/dn/9JMzJ/btrJLTCvTPF/Sp0EPod3CzkIrFTvBDYRvK/img.jpg)
풀이
select max(population) - min(population)
from city
'Data Analysis > SQL' 카테고리의 다른 글
[HackerRank] Top Earners (MySQL) (0) | 2022.08.15 |
---|---|
[HackerRank] The Blunder (MySQL) (0) | 2022.08.15 |
[HackerRank] Japan Population (MySQL) (0) | 2022.08.12 |
[HackerRank] Average Population (0) | 2022.08.12 |
[HackerRank] Revising Aggregations- Averages (MySQL) (0) | 2022.08.12 |
Comments