[hackerrank] Prepare > SQL > Aggregation > Revising Aggregations - Averages
[문제]
Query the average population of all cities in CITY where District is California.
Input Format
The CITY table is described as follows:
[MYSQL]
[ORCALE]
select avg(population)
from city
where district = 'California';
반응형
'HackerRank > SQL' 카테고리의 다른 글
[hackerrank] Japan Population (0) | 2022.08.24 |
---|---|
[hackerrank] Average Population (0) | 2022.08.24 |
[hackerrank] Revising Aggregations - The Sum Function (0) | 2022.08.24 |
[hackerrank] Weather Observation Station 20 (0) | 2022.08.22 |
[hackerrank] Revising Aggregations - The Count Function (0) | 2022.08.22 |