Im between cherry

Hackerrank | MySQL | Revising Aggregations - The Count Function 본문

데이터분석/practice_query

Hackerrank | MySQL | Revising Aggregations - The Count Function

meal 2020. 8. 28. 09:30

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

Query a count of the number of cities in CITY having a Population larger than100,000.

 

 

 

- solution

SELECT COUNT(*)
FROM city
WHERE population > 100000

 

저작자표시 (새창열림)

'데이터분석 > practice_query' 카테고리의 다른 글

Hackerrank | MySQL | Revising Aggregations - Averages  (0) 2020.08.28
Hackerrank | MySQL | Revising Aggregations - The Sum Function  (0) 2020.08.28
Hackerrank | MySQL | Employee Salaries  (0) 2020.08.28
Hackerrank | MySQL | Employee Names  (0) 2020.08.28
Hackerrank | MySQL | Higher Than 75 Marks  (0) 2020.08.28
'데이터분석/practice_query' Related Articles more
Comments