Skip to content

Revising Aggregations Averages

1. 문제

문제 확인하기

2. 정답 코드 (MySQL)

SELECT SUM(POPULATION)/COUNT(NAME) FROM CITY
WHERE DISTRICT = 'California';

3. 다른 정답 코드 (MySQL)

SELECT AVG(POPULATION) FROM CITY
WHERE DISTRICT = 'California';