✅ Revising Aggregations - The Count Function
📝 문제
Query a count of the number of cities in CITY having a Population larger than 1000
Input Format
The CITY table is described as follows:
💻 풀이
SELECT COUNT(*)
FROM CITY
WHERE POPULATION > 100000;Query a count of the number of cities in CITY having a Population larger than 1000
Input Format
The CITY table is described as follows:
SELECT COUNT(*)
FROM CITY
WHERE POPULATION > 100000;