Im between cherry

Hackerrank | MySQL | Average Population 본문

데이터분석/practice_query

Hackerrank | MySQL | Average Population

meal 2020. 8. 28. 09:35

Average Population

Problem

Query the average population for all cities in CITY, rounded down to the nearest integer.

 

 

SELECT FLOOR(AVG(population))
FROM city
Comments