일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 | 29 | 30 | 31 |
Tags
- 개발자의 책장
- 재귀함수
- for문
- array
- 코딩공부
- 블록체인
- Hackerrank
- JavaScript
- array.push()
- 프로그래머스
- 알고리즘
- 코딩테스트
- Programmers
- 역행자
- Developer_JoyKim
- 최강의 인생
- node.js
- 자바스크립트
- 배열
- Algorithms
- MySQL
- 개발자_조이킴
- 정규표현식
- 코플릿
- SQL
- join
- Where
- 코드스테이츠
- array.slice()
- select
Archives
- Today
- Total
CodingSpace
[HackerRank/SQL] Revising Aggregations - Averages 본문
Problem. Revising Aggregations - Averages
Link.
Revising Aggregations - Averages | HackerRank
Query the average population of all cities in the District of California.
www.hackerrank.com
Description.
Query the sum of the populations for all Japanese cities in CITY.
Key Point.
SELECT,
SUM,
WHERE,
My Answer.
SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = 'JPN';
References.
'HackerRank > SQL' 카테고리의 다른 글
[HackerRank/SQL] Revising Aggregations - The Blunder (0) | 2022.07.17 |
---|---|
[HackerRank/SQL] Revising Aggregations - Population Density Difference (0) | 2022.07.17 |
[HackerRank/SQL] Revising Aggregations - Average Population (0) | 2022.07.14 |
[HackerRank/SQL] Revising Aggregations - Averages (0) | 2022.07.12 |
[HackerRank/SQL] Revising Aggregations - The Sum Function (0) | 2022.07.10 |
Comments