[SQL][HackerRank] Revising Aggregations - Averages

https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen

Revising Aggregations - Averages | HackerRank

Query the average population of all cities in CITY where District is California.

Input Format

The CITY table is described as follows:

• query average population ==> SELECT AVG(POPULATION)
• in CITY table ==> FROM CITY
• District is California ==> WHERE DISTRICT = ‘California’

      

      

      

    
    

      <sql />
    
SELECT AVG(POPULATION)
FROM CITY
WHERE DISTRICT = 'California';