GROUP BY, ORDER BY clauses

[Asad Habib]

Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in
conjunction with one another? I have tried to execute several queries
with both these clauses but the result set I get is different from what I
expect. My queries read as follows:

SELECT *, *, * FROM *
WHERE *
GROUP BY * ORDER BY *

Also, does GROUP BY only work on fields that are strings (i.e.
CHAR, VARCHAR, TEXT, etc.). Thanks in advance.

- Asad