Revising Aggregations - Averages

Sort by

recency

|

422 Discussions

|

  • + 0 comments

    select avg(population) from city where district = 'Califonia';

  • + 0 comments

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

  • + 0 comments

    MySQL Code:

    SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT = 'California'
    
  • + 0 comments

    SELECT AVG(POPULATION) FROM CITY GROUP BY DISTRICT HAVING DISTRICT="CALIFORNIA"

  • + 1 comment

    SELECT avg(population) FROM city WHERE district='california';

    easy solution query