728x90
반응형
문제
Query the average population of all cities in CITY where District is California.
Input Format
The CITY table is described as follows:
Code
SELECT AVG(POPULATION)
FROM CITY
WHERE DISTRICT = 'CALIFORNIA'
728x90
반응형
'SQL > MySQL' 카테고리의 다른 글
[MySQL/HackerRank] Japan Population (0) | 2023.08.21 |
---|---|
[MySQL/HackerRank] Average Population (0) | 2023.08.21 |
[MySQL/HackerRank] Revising Aggregations - The Sum Function (0) | 2023.08.21 |
[MySQL/HackerRank] Revising Aggregations - The Count Function (0) | 2023.08.21 |
[MySQL/HackerRank] The PADS (0) | 2023.08.21 |