| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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
- sort
- 자연어처리
- DeepLearning
- algorithm
- FullyConnectedLayer
- backward
- affine
- boj
- PPMI
- skip-gram
- Stack
- 파이썬
- MySQL
- select
- Programmers
- Sigmoid
- Python
- 프로그래머스
- 딥러닝
- dl
- que
- kakao
- CBOW
- stak
- hash
- Heap
- Numpy
- Word2vec
- SQL
- 신경망
Archives
- Today
- Total
혜온의 이것저것
[HackerRank] Average Population 본문
https://www.hackerrank.com/challenges/average-population/problem?isFullScreen=true
Average Population | HackerRank
Query the average population of all cities, rounded down to the nearest integer.
www.hackerrank.com
문제
Query the average population for all cities in CITY, rounded down to the nearest integer.
Input Format
The CITY table is described as follows:
풀이
select floor(avg(population))
from city'Data Analysis > SQL' 카테고리의 다른 글
| [HackerRank] Population Density Difference (MySQL) (0) | 2022.08.15 |
|---|---|
| [HackerRank] Japan Population (MySQL) (0) | 2022.08.12 |
| [HackerRank] Revising Aggregations- Averages (MySQL) (0) | 2022.08.12 |
| [HackerRank] Revising Aggregations- The Sum Function (MySQL) (0) | 2022.08.12 |
| [HackerRank] Revising Aggregations- The Count Function (MySQL) (0) | 2022.08.12 |
'Data Analysis/SQL' Related Articles
more
Comments