Query: List of top 100 Nigerian Stack Overflow users

users.sql

SELECT TOP 100
    ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS [#], 
    Id AS [User Link], 
    Reputation
FROM
    Users
WHERE
    LOWER(Location) LIKE '%nigeria%'
    OR UPPER(Location) LIKE '%NIGERIA%'
ORDER BY
    Reputation DESC;
    
    
    
    
/////////////////////////////////////////////////////////////////////////////////////////////////////////////

#   User Link                   Reputation 
--- --------------------------- ---------- 
1   Oluwafemi Sule              26320      
2   Ojonugwa Jude Ochalifu      23822      
3   WhiZTiM                     19840      
4   Jalasem                     18442      
5   user1234440                 17752      
6   scartag                     16837      
7   Emeka Mbah                  13469      
8   Babatunde Adeyemi           13451      
9   Tebo                        13445      
10  Eyo Okon Eyo                13368      
11  nponeccop                   13094      
12  elo80ka                     11519      
13  Chibueze Opata              9238       
14  Leo Aso                     9062       
15  Charles Okwuagwu            8893       
16  danidee                     8097       
17  afaolek                     7347       
18  Olaseni                     7210       
19  Promise Preston             6790       
20  Olufemi Israel Olanipekun   6756       
21  Ogbonna Vitalis             6677       
22  antzshrek                   6406       
23  void                        6284       
24  Shittu Joseph Olugbenga     6068       
25  Chibuzo                     6004       
26  Peter                       5890       
27  Joberror                    5480       
28  Kingsley Kbc Comics         5329       
29  nonybrighto                 5280       
30  codejockie                  5264       
31  Taslim Oseni                4398       
32  user618677                  4173       
33  Seunope                     3917       
34  EngrEric                    3904       
35  kehers                      3854       
36  Favourite Onwuemene         3757       
37  x6iae                       3625       
38  Ahmed Onawale               3602       
39  Pila                        3419       
40  Tosin Onikute               3333       
41  Bosah Chude                 3300       
42  X09                         3197       
43  Transformer                 3110       
44  Uchenna Nwanyanwu           3094       
45  GuruKay                     3062       
46  gbozee                      2996       
47  demo.b                      2899       
48  James Okpe George           2899       
49  Jerry Okafor                2865       
50  user28864                   2855       
51  Awa Melvine                 2845       
52  preciousbetine              2839       
53  Ifedi Okonkwo               2818       
54  NaijaProgrammer             2783       
55  Nosakhare Belvi             2735       
56  MrFoh                       2535       
57  Inducesmile                 2409       
58  The Billionaire Guy         2360       
59  ikben                       2235       
60  okey_on                     2198       
61  0.sh                        2166       
62  Giddy Naya                  2142       
63  Gurumoorthy Arumugam        2081       
64  Victor.Uduak                2078       
65  Wakeel                      2058       
66  Ahmed Adewale               2051       
67  Chukwuemeka Inya            2047       
68  Akintunde                   1995       
69  Kennedy                     1977       
70  aphoe                       1946       
71  iChux                       1946       
72  Ody                         1930       
73  SilenceDev                  1921       
74  Anga                        1916       
75  Tunmee                      1914       
76  Canaan Etai                 1914       
77  Udo E.                      1888       
78  Oladipo Olasemo             1850       
79  Ewomazino Ukah              1833       
80  Bernard 'Beta Berlin' Parah 1811       
81  ken4ward                    1775       
82  Shina                       1743       
83  Paullo                      1736       
84  Van_Paitin                  1731       
85  OGx09                       1729       
86  chidimo                     1696       
87  Seyi Daniel                 1663       
88  Jide                        1654       
89  Adépòjù Olúwáségun          1648       
90  burntblark                  1640       
91  Abk                         1633       
92  bolkay                      1622       
93  JohnTheBeloved              1621       
94  Tunji Oyeniran              1619       
95  oziomajnr                   1599       
96  Adeojo Emmanuel IMM         1596       
97  Idee                        1588       
98  keni                        1556       
99  maroof shittu               1549       
100 Afolabi Olaoluwa Akinwumi   1532       

(100 row(s) returned)

where almost all of them are from the southern part...