[olug] OLUG's late nighters and early risers

[Mat]

Well, Mr. Wiese, since you asked for it, here it is.

   :)


select left(author,20),count(*) as weehours from emails where
hour(time)=1 group by author order by weehours desc;
+----------------------+----------+
| left(author,20)      | weehours |
+----------------------+----------+
| Brian Wiese <bwiese@ |       13 |
| "Brian Roberson" <ro |        5 |
| Christopher Cashell  |        4 |
| Phil Brutsche <phil@ |        4 |
| Jay Hannah <jay at jays |        3 |
| Unix Guru Universe < |        3 |
| Eric Pierce <eric_ol |        2 |
| Vincent.Raffensberge |        2 |

select left(author,20),count(*) as weehours from emails where
hour(time)=2 group by author order by weehours desc;
+----------------------+----------+
| left(author,20)      | weehours |
+----------------------+----------+
| nate <tbrownarcher at c |        4 |
| Brian Wiese <bwiese@ |        3 |
| Christopher Cashell  |        3 |
| Unix Guru Universe < |        2 |
| "K.J. Kirwan" <kjk_e |        2 |
| Phil Brutsche <phil@ |        1 |
| "Bob McCoy" <bob at mcc |        1 |


select left(author,20),count(*) as earlyhours from emails where
hour(time)=7 group by author order by earlyhours desc;
+----------------------+------------+
| left(author,20)      | earlyhours |
+----------------------+------------+
| CM Miller <cmmiller1 |         10 |
| "Craig Wolf" <CJWolf |          9 |
| Jay Hannah <jay at jays |          6 |
| "Eric Penne" <epenne |          3 |
| "Bob McCoy" <bob at mcc |          3 |
| "Jon H. Larsen" <rel |          3 |
| "Nathan Rotschafer ( |          2 |


select left(author,20),count(*) as earlyhours from emails where
hour(time)=8 group by author order by earlyhours desc;
+----------------------+------------+
| left(author,20)      | earlyhours |
+----------------------+------------+
| Jay Hannah <jay at jays |         12 |
| "Craig Wolf" <CJWolf |         12 |
| "Ryan O'Rourke" <rya |          9 |
| "Trent Melcher" <tme |          8 |
| Brandon Lederer <bra |          8 |
| "Mike Peterson CoxMa |          6 |
| Sam Tetherow <tether |          6 |
| neal rauhauser <neal |          6 |
| "Jon H. Larsen" <rel |          5 |
| Eric Johnson <eric_j |          4 |
| "Tim - DZ" <iceburn@ |          4 |