Hello coders, today we are going to solve Revising Aggregations – The Sum Function HackerRank Solution in SQL.
Query the total population of all cities in CITY where District is California.
The CITY table is described as follows:
Solution – Revising Aggregations – The Sum Function in SQL
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.