반응형
문제 링크입니다!
Japan Population | HackerRank
Query to the sum of the populations of all Japanese cities in CITY.
www.hackerrank.com
문제
=> CITY 테이블에서 COUNTRYCODE가 JPN인 POPULATION 컬럼의 합계를 조회해라
풀이
SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE = 'JPN'
https://docs.microsoft.com/ko-kr/sql/t-sql/functions/sum-transact-sql?view=sql-server-2017
SUM(Transact-SQL) - SQL Server
SUM(Transact-SQL)
docs.microsoft.com
'HackerRank - MS SQL Server' 카테고리의 다른 글
| [해커랭크/MS SQL] Top Earners (0) | 2022.03.25 |
|---|---|
| [해커랭크/MS SQL] The Blunder (0) | 2022.03.25 |
| [해커랭크/MS SQL] Average Population (0) | 2022.03.25 |
| [해커랭크/MS SQL] Revising Aggregations - Averages (0) | 2022.03.25 |
| [해커랭크/MS SQL] Revising Aggregations - The Sum Function (0) | 2022.03.25 |
댓글