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';
Codesadda.com is your home of programming solutions, tutorials, video tutorials and much more. Sign Up for our weekly newsletter to get update about new content.