Hello coders, In this post, you will learn how to solve the Revising Aggregations Averages Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.
Problem
Query the average population of all cities in CITY where District is California.
Input Format
The CITY table is described as follows:
Revising Aggregations Averages Hacker Rank Solution
select avg(POPULATION) from CITY WHERE DISTRICT = 'California';
Disclaimer: The above Problem (Revising Aggregations – Averages) generated by Hackerrank but the Solution is Provided by Chase2Learn. This tutorial is only for Educational and Learning purposes.