Request for fun queries

[Cyburbia]

I'm sure some of the PHP experts here have some interesting queries. I wish I knew of some, which is why I'm starting this thread.

One query I've been looking for is to find the average number of words in a post by user, to see if the users that are supposedly long-winded are indeed so. Anyone have any idead about how to code such a query? Any other fin queries you would like to share with those of us for are a bit more technically inept?

[filburt1]

Such a query would be extremely inefficient. It would likely be easier to cache the number of words in each post and then read from that cache to derive the average.