-
[HackerRank/Aggregation] Revising Aggregations - The Count Function공부/PS ( SQL) 2022. 5. 17. 01:19
https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem
Revising Aggregations - The Count Function | HackerRank
Query the number of cities having populations larger than 100000.
www.hackerrank.com
문제
풀이
SELECT COUNT(NAME) FROM CITY WHERE POPULATION > 100000
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Aggregation] Revising Aggregations - Average Population (0) 2022.05.18 [HackerRank/Aggregation] Revising Aggregations - Averages (0) 2022.05.18 [HackerRank/Advanced Select] The PADS (0) 2022.05.16 [HackerRank/Advanced Select] Type of Triangle (0) 2022.05.16 [HackerRank/Basic Select] Employee Salaries (0) 2022.05.16