일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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
- SQL
- JavaScript
- array
- select
- 자바스크립트
- Where
- Algorithms
- 개발자의 책장
- 코딩공부
- MySQL
- Programmers
- 코딩테스트
- 프로그래머스
- 알고리즘
- for문
- join
- array.push()
- 역행자
- 블록체인
- Developer_JoyKim
- array.slice()
- 코드스테이츠
- Hackerrank
- 코플릿
- 개발자_조이킴
- 최강의 인생
- 배열
- 재귀함수
- 정규표현식
- node.js
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