순간을 기록으로

[MySQL] Revising Aggregations | 본문

Problem Solving

[MySQL] Revising Aggregations |

luminous13 2022. 4. 5. 19:13

문제

 

 

- 인구수가 100,000을 초과하는 도시의 갯수를 조회하세요

풀이

select count(*)
from city
where population > 100000;

출처: https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem?isFullScreen=true 

 

Revising Aggregations - The Count Function | HackerRank

Query the number of cities having populations larger than 100000.

www.hackerrank.com

 

Comments