Revising Aggregations - The Sum Function

Sort by

recency

|

480 Discussions

|

  • + 0 comments

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

  • + 0 comments

    select sum(population) as total_population from CITY where district = 'California';

  • + 0 comments

    SELECT SUM(population) FROM city WHERE district = "california" ;
    spaces also do matter so in quotes always write exact name

  • + 0 comments

    select sum(population) "Total Population" from city where district='California';

  • + 0 comments

    SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT="California";