We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Revising Aggregations - The Count Function
Revising Aggregations - The Count Function
Sort by
recency
|
513 Discussions
|
Please Login in order to post a comment
select count(distinct city.name) from city where city.population > 100000;
SELECT COUNT(*) AS city_count FROM CITY WHERE Population > 100000;
select sum(population) from (select count(population) as population from CITY where population > 100000 group by population) as citypopulation
SELECT COUNT (*) FROM CITY WHERE Population>100000;
SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000;