Hello coders, today we are going to solve Revising Aggregations – Averages HackerRank Solution in SQL.
Problem
Query the average population of all cities in CITY where District is California.
Input Format
The CITY is described as follows:
| Field | Type |
|---|---|
| ID | NUMBER |
| NAME | VARCHAR2(17) |
| COUNTRYCODE | VARCHAR2(3) |
| DISTRICT | VARCHAR2(20) |
| POPULATION | NUMBER |
Solution – Revising Aggregations – Averages in SQL
MySQL
select avg(population) from city where district='California';
Disclaimer: The above Problem (Revising Aggregations – Averages) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.