Created
March 2, 2021 12:00
-
-
Save Developerayo/cc4540a2dafd978986888a5e8766b847 to your computer and use it in GitHub Desktop.
Query: List of top 100 Nigerian Stack Overflow users
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
where almost all of them are from the southern part...