순간을 기록으로

[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

 

'Problem Solving' 카테고리의 다른 글

[MySQL] Revising Aggregations - Averages  (0) 2022.04.05
[MySQL] Revising Aggregations - The Sum Function  (0) 2022.04.05
[MySQL] The PADS | CONCAT 함수  (0) 2022.03.30
[MySQL] Type of Triangle | CASE문(조건문)  (0) 2022.03.29
[MySQL] Top Earners | GROUP BY | SQL 구 작동순서  (0) 2022.03.29
'Problem Solving' Related Articles more
Comments