Prepare> SQL > Aggregation > Revising Aggregations - The Count Function
2023. 5. 16. 20:54ㆍHackerRank-My SQL
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.
코드
SELECT COUNT(COUNTRYCODE) FROM CITY
WHERE POPULATION > 100000;
'HackerRank-My SQL' 카테고리의 다른 글
| Prepare > SQL > Aggregation > Revising Aggregations - Averages (0) | 2023.05.16 |
|---|---|
| Prepare > SQL > Aggregation > Revising Aggregations - The Sum Function (0) | 2023.05.16 |
| Prepare > SQL > Aggregation > The Blunder (0) | 2023.05.16 |
| Prepare > SQL > Aggregation > Population Density Difference (0) | 2023.05.16 |
| Prepare > SQL > Aggregation > Japan Population (0) | 2023.05.16 |