융무의 기술블로그
article thumbnail

https://www.hackerrank.com/challenges/revising-aggregations-sum/problem?h_r=next-challenge&h_v=zen

 

Revising Aggregations - The Sum Function | HackerRank

Query the total population of all cities for in the District of California.

www.hackerrank.com

Query the total population of all cities in CITY where District is California.

Input Format

The CITY table is described as follows:

  • query total population ==> SELECT SUM(POPULATION)
  • in CITY table ==> FROM CITY
  • District is California ==> WHERE DISTRICT = ‘California’
SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT = 'California';

profile

융무의 기술블로그

@융무

포스팅이 좋았다면 "좋아요❤️" 또는 "구독👍🏻" 해주세요!