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 than 100,000.
Input Format
The CITY table is described as follows:
[My Answer]
SELECT COUNT(NAME)
FROM CITY
WHERE POPULATION > 100000난이도 왜 갑자기..?
'Code Problems > SQL_ HackerRank' 카테고리의 다른 글
| [HackerRank] The Blunder (0) | 2021.11.07 |
|---|---|
| [HackerRank] Revising Aggregations, Populations (0) | 2021.11.07 |
| [HackerRank] New Company (0) | 2021.11.06 |
| [HackerRank] Binary Tree Nodes (0) | 2021.11.06 |
| [HackerRank] Occupations (0) | 2021.10.23 |