Revising Aggregations - Averages
- URL : https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem
- Query the average population of all cities in CITY where District is California.
- MySQL Solution
1
2
3
select avg(population)
from city
where district = 'California'