StackOverflow users in Africa (count)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select
U.Location,
COUNT(U.Location) [Total Users]

from Users U

where
upper(U.Location) like '%KENYA%'
or upper(U.Location) like '%CONGO%'
or upper(U.Location) like '%NIGERIA%'
or upper(U.Location) like '%AFRICA%'
or upper(U.Location) like '%ZAMBIA%'
or upper(U.Location) like '%ANGOLA%'
or upper(U.Location) like '%ZIM%'

group by
U.Location

with cube

order by
[Total Users] desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results