Skip to content

Instantly share code, notes, and snippets.

@mmattozzi
Created September 24, 2009 19:54
Show Gist options
  • Save mmattozzi/192992 to your computer and use it in GitHub Desktop.
Save mmattozzi/192992 to your computer and use it in GitHub Desktop.
mysql> select nick, count(*) c from messages group by nick order by c desc;
+------------------+-------+
| nick | c |
+------------------+-------+
| jvolkman | 11629 |
| mmattozzi | 9547 |
| mblinn | 9017 |
| aevans | 7589 |
| mhawthorne | 5247 |
| bschmaus | 2543 |
| dillera | 2541 |
| eschrag | 1770 |
| vfumo | 1438 |
| jdiprinzio | 1113 |
| mschaffer | 973 |
| cimeleon | 93 |
| massiveRobot | 88 |
| dwango | 53 |
| jfeller | 45 |
| jlee | 31 |
| arpit | 23 |
| drumminmiles | 14 |
| Joemamma | 11 |
| jfelle6813c | 11 |
| hexen | 11 |
| sonofdwango | 9 |
| jbell | 8 |
| mmattozzi-cimele | 7 |
| schaffermat | 6 |
| tylerdurden | 6 |
| jonjlee | 6 |
| bvasko000 | 3 |
| jvolkmanisahussy | 3 |
| diller2 | 3 |
| tmblinn | 2 |
| mschaffer-cimele | 2 |
| jvolkman-cimeleo | 2 |
| mattozzi | 2 |
| srife | 2 |
| person4 | 2 |
| dwangodisciple | 1 |
| matschaffer | 1 |
| mschaffer1 | 1 |
| bvasko | 1 |
+------------------+-------+
40 rows in set (0.10 sec)
mysql> select count(*) from messages;
+----------+
| count(*) |
+----------+
| 53857 |
+----------+
1 row in set (0.00 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment