HackerRank MySQL - Revising Aggregations - The Sum Function
Query the total population of all cities in CITY where District is California.
- SELECT SUM(POPULATION)
- FROM CITY
- WHERE DISTRICT = 'California';
Query the total population of all cities in CITY where District is California.
- SELECT SUM(POPULATION)
- FROM CITY
- WHERE DISTRICT = 'California';
Codesadda.com is your home of programming solutions, tutorials, video tutorials and much more. Sign Up for our weekly newsletter to get update about new content.