You are viewing a single comment's thread. Return to all comments →
Hi i've tried another solution but i don't know why it's wrong:
SELECT COUNT(CASE WHEN Population > 100000 THEN 1 ELSE 0 END) AS result FROM City;
Seems like cookies are disabled on this browser, please enable them to open this website
Revising Aggregations - The Count Function
You are viewing a single comment's thread. Return to all comments →
Hi i've tried another solution but i don't know why it's wrong: