We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Revising Aggregations - Averages
Revising Aggregations - Averages
Sort by
recency
|
422 Discussions
|
Please Login in order to post a comment
select avg(population) from city where district = 'Califonia';
SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT = 'California' -- MySQL
MySQL Code:
SELECT AVG(POPULATION) FROM CITY GROUP BY DISTRICT HAVING DISTRICT="CALIFORNIA"
SELECT avg(population) FROM city WHERE district='california';
easy solution query