[HackerRank] Basic Aggregation : Revising Aggregations

Input Format

The CITY table is described as follows:

Q1. Query the total population of all cities in CITY where Districtis California.

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

Q2. Query the average population of all cities in CITY where District is California.

SELECT AVG(POPULATION) FROM CITY 
    WHERE DISTRICT = 'California'

Q3. Query the average population for all cities in CITY, rounded down to the nearest integer.

SELECT FLOOR(AVG(POPULATION)) FROM CITY

Q4. Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.

SELECT SUM(POPULATION) FROM CITY
    WHERE COUNTRYCODE = 'JPN'

Q5. Query the difference between the maximum and minimum populations in CITY.

SELECT MAX(POPULATION) - MIN(POPULATION) FROM CITY

댓글(0)

Designed by JB FACTORY