Im between cherry

Hackerrank | MySQL | Revising Aggregations - Averages 본문

데이터분석/practice_query

Hackerrank | MySQL | Revising Aggregations - Averages

meal 2020. 8. 28. 09:34

Revising Aggregations - Averages

Problem

 

Revising Aggregations - Averages | HackerRank

Query the average population of all cities in the District of California.

www.hackerrank.com

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

 

 

SELECT AVG(population)
FROM city
WHERE district = 'California'
Comments