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 - The Sum Function
Revising Aggregations - The Sum Function
Sort by
recency
|
480 Discussions
|
Please Login in order to post a comment
SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = 'California';
select sum(population) as total_population from CITY where district = 'California';
SELECT SUM(population) FROM city WHERE district = "california" ;
spaces also do matter so in quotes always write exact name
select sum(population) "Total Population" from city where district='California';
SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT="California";