Using avg, min, max functions on a non-numeric field.

[Graeme B. Davis]

I have a database such as:

user (char)
category (char)
modified (datetime)

I want to get the average number of entries per day (possibly broken down by
category, but not necessary) -- how would I do this?

I want this to be done with all users in the db such as

user      average entries      
min, max
-------   ---------------  -------------
johndoe                
43          8,93

Any suggestions?

Graeme "SQL bum" D. :)