Page MenuHomePhabricator
Paste P17313

(An Untitled Masterwork)
ActivePublic

Authored by Urbanecm_WMF on Sep 22 2021, 7:50 AM.
Tags
None
Referenced Files
F34650633: raw-paste-data.txt
Sep 22 2021, 7:50 AM
Subscribers
None
mysql:research@dbstore1005.eqiad.wmnet [enwiki]> select row_number() over (order by count(*) desc) as '#', count(*) from growthexperiments_mentor_mentee gr$up by gemm_mentor_id order by count(*) desc;
+----+----------+
| # | count(*) |
+----+----------+
| 1 | 30220 |
| 2 | 30008 |
| 3 | 29765 |
| 4 | 29143 |
| 5 | 28051 |
| 6 | 27981 |
| 7 | 27626 |
| 8 | 26742 |
| 9 | 24742 |
| 10 | 24362 |
| 11 | 23564 |
| 12 | 22697 |
| 13 | 22252 |
| 14 | 19505 |
| 15 | 18742 |
| 16 | 17838 |
| 17 | 17595 |
| 18 | 17185 |
| 19 | 16167 |
| 20 | 5967 |
| 21 | 5946 |
| 22 | 4008 |
| 23 | 2558 |
| 24 | 2505 |
| 25 | 2434 |
| 26 | 990 |
| 27 | 918 |
| 28 | 908 |
| 29 | 854 |
| 30 | 849 |
| 31 | 780 |
| 32 | 627 |
| 33 | 382 |
| 34 | 159 |
| 35 | 134 |
| 36 | 59 |
| 37 | 56 |
| 38 | 1 |
| 39 | 1 |
+----+----------+
39 rows in set (0.141 sec)
mysql:research@dbstore1005.eqiad.wmnet [enwiki]>