hackerrank revising aggregations3 [MySQL] Revising Aggregations - Averages ▶ SQL > Aggregation > Revising Aggregations - Averages Problem Query the average population of all cities in CITY where District is California. Input Format The CITY table is described as follows: My Answer SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT = 'California' 2021. 4. 20. [MySQL] Revising Aggregations - The Sum Function SQL > Basic Select > Revising Aggregations - The Sum Function Problem Query the total population of all cities in CITY where District is California. Input Format The CITY table is described as follows: My Answer SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = 'California' 2021. 4. 20. [MySQL] Revising Aggregations - The Count Function ▶ SQL > Aggregation > Revising Aggregations - The Count Function Problem Query a count of the number of cities in CITY having a Population larger than 100,000. Input Format The CITY table is described as follows: My Answer SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000 2021. 4. 20. 이전 1 다음 728x90
