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