Revising Aggregations The Sum Function – Hacker Rank Solution

Revising Aggregations The Sum Function - Hacker Rank Solution
Revising Aggregations The Sum Function – Hacker Rank Solution

Problem

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

Input Format

The CITY table is described as follows:

 

Oracle



Revising Aggregations The Sum Function – Hacker Rank Solution

SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT = 'California';

Disclaimer: The above Problem (Revising Aggregations – The Sum Function) generated by Hackerrank but the Solution is Provided by codeworld19 . This tutorial is only for Educational and Learning purposes. Authority if any of the queries regarding this post or website fill the following contact form thank you.

Leave a Comment

Your email address will not be published. Required fields are marked *