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
|
474 Discussions
|
Please Login in order to post a comment
Query the total population of all cities in CITY where District is California.
select sum(population) from City where district ='California'; this code is correct .
SELECT SUM(Population) FROM CITY WHERE District = 'California';
SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = 'California';
SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT = 'California';