Revising Aggregations - Averages | HackerRank
Query the average population of all cities in the District of California.
www.hackerrank.com
SELECT AVG(population)
FROM city
WHERE district = 'California'
'Algorithm & SQL > HackerRank' 카테고리의 다른 글
| [HakerRank / MySQL] African Cities (0) | 2024.03.10 |
|---|---|
| [HackerRank / MySQL] Type of Triangle (0) | 2024.03.10 |
| [HackerRank / MySQL] Top Earners (0) | 2024.03.10 |
| [HackerRank / MySQL] Weather Observation Station 15 (0) | 2024.03.09 |
| [HackerRank / MySQL] Higher Than 75 Marks (0) | 2024.03.09 |
