Prepare > SQL > Aggregation > Revising Aggregations - Averages

Revising Aggregations - Averages | HackerRank

 

문제

---

Query the average population of all cities in CITY where District is California.

 

 

 

 

코드

---

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

 

 

두 번재 시도

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