Revising Aggregations - The Count Function
Q
SELECT COUNT(ID)
FROM CITY
WHERE POPULATION > 100000
Revising Aggregations - The Sum Function
Q
SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT LIKE 'California'
Revising Aggregations - Averages
Q
SELECT AVG(POPULATION)
FROM CITY
WHERE DISTRICT LIKE 'California'
Average Population
Q
ROUND
SELECT ROUND(AVG(POPULATION),0)
FROM CITY
FLOOR
SELECT FLOOR(AVG(POPULATION))
FROM CITY;
Japan Population
Q
SELECT SUM(POPULATION)
FROM CITY
WHERE COUNTRYCODE LIKE 'JPN'
Population Density Difference
Q
SELECT MAX(POPULATION)-MIN(POPULATION)
FROM CITY
