Revising Aggregations - The Sum Function:- HackerRank Solution in MYSQL

Problem:-

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

Input Format

The CITY table is described as follows:

Solution:-


select sum(population)
from city

where district="California"