[HackerRank/SQL] Revising Aggregations - Average Population

Problem. Revising Aggregations - Averages Population

---

Link.

https://www.hackerrank.com/challenges/average-population/problem?utm_campaign=challenge-recommendation&utm_medium=email&utm_source=24-hour-campaign

Revising Aggregations - Averages | HackerRank

---

Description.

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

CITY 테이블

---

Key Point. 

SELECT,

 

AVG,

 

ROUND,

---

My Answer. 

SELECT ROUND(AVG(POPULATION))
FROM CITY;

---

References.