-
[HackerRank/Aggregation] Revising Aggregations - Averages공부/PS ( SQL) 2022. 5. 18. 02:10
https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem
Revising Aggregations - Averages | HackerRank
Query the average population of all cities in the District of California.
www.hackerrank.com
문제
풀이
SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT LIKE 'California'
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Basic Join] Population Census (0) 2022.05.18 [HackerRank/Aggregation] Revising Aggregations - Average Population (0) 2022.05.18 [HackerRank/Aggregation] Revising Aggregations - The Count Function (0) 2022.05.17 [HackerRank/Advanced Select] The PADS (0) 2022.05.16 [HackerRank/Advanced Select] Type of Triangle (0) 2022.05.16