Re: How to obtain most popular cities from my users table

[Stephen Counsell]

hi,
Try this:

select CITY_ID as city, count(*) as num from users group by CITY_ID;

I've not tested that statement but it should work.

What you should see is:
city num
32 3
20 1
5 1

regards
Steve