HackerRank MySQL - Revising Aggregations - Averages
Query the average population of all cities in CITY where District is California.
- SELECT AVG(POPULATION)
- FROM CITY
- WHERE DISTRICT = 'California';
Query the average population of all cities in CITY where District is California.
- SELECT AVG(POPULATION)
- FROM CITY
- WHERE DISTRICT = 'California';