문제
Query the average population of all cities in CITY where District is California.
Input Format
The CITY table is described as follows:
코드
Select AVG(population)
From City
Where district = 'California'
- City 테이블에서 California의 인구 평균 구하기
출처
반응형
'Algorithm > MySQL' 카테고리의 다른 글
[LeetCode] 595. Big Countries (MySQL) (0) | 2021.07.05 |
---|---|
[해커랭크(HackerRank)] Average Population (MySQL) (0) | 2021.07.04 |
[해커랭크(HackerRank)] Weather Observation Station 11 (MySQL) (0) | 2021.07.04 |
[해커랭크(HackerRank)] Weather Observation Station 10 (MySQL) (0) | 2021.07.04 |
[해커랭크(HackerRank)] Weather Observation Station 9 (MySQL) (0) | 2021.07.04 |