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.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Revising Aggregations - Averages
  5. Discussions

Revising Aggregations - Averages

Sort by

recency

|

388 Discussions

|

  • SVVBathini
     + 0 comments

    For MySQL

    SELECT AVG(population) FROM city
WHERE district = "california";

  • shreyanshsaurav1
     + 0 comments

    SELECT AVG(C.POPULATION) AS AVG_POPULATION FROM CITY C WHERE C.DISTRICT = 'California';

  • shivarajesh91
     + 0 comments

    mysql:

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

  • kavithasachin26
     + 0 comments

    for oracle

    select AVG(population) from CITY where district ='California';

  • mayank9450612583
     + 0 comments

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