[olug] OLUG's late nighters and early risers

Ryan O'Rourke ryano at ch-gifts.com
Tue Dec 23 17:42:55 UTC 2003


On Tue, 2003-12-23 at 11:21, Mat wrote:
> select left(author,20),count(*) as earlyhours from emails where
> hour(time)=7 group by author order by earlyhours desc;

> select left(author,20),count(*) as earlyhours from emails where
> hour(time)=8 group by author order by earlyhours desc;

These queries are the /real/ tests of fortitude -- anybody can stay up
late, only the truly strong can get up early! ;-)




More information about the OLUG mailing list