Revising Aggregations – The Sum Function in SQL | HackerRank Solution

Hello coders, today we are going to solve Revising Aggregations – The Sum Function HackerRank Solution in SQL.

Problem

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

Input Format

The CITY table is described as follows:

Field	Type
ID	NUMBER
NAME	VARCHAR2(17)
COUNTRYCODE	VARCHAR2(3)
DISTRICT	VARCHAR2(20)
POPULATION	NUMBER

Solution – Revising Aggregations – The Sum Function in SQL

MySQL

select sum(population)
from city
where district ='California';

Disclaimer: The above Problem (Revising Aggregations – The Sum Function) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.