03 - Revising Aggregations - Averages.sql

-- ========================
--       Information
-- ========================

-- Direct Link: https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem
-- Difficulty: Easy
-- Max Score: 10
-- DBMS: mySQL

-- ========================
--         Solution
-- ========================

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