The following does NOT produce an error on the 'order by' clause,
though perhaps it should?
SELECT col, count(*) from table group by col order by count;
If there is more than one count() function in the query, it does crete
am error for the ambiguous reference.
(FWIW, Oracle and MySQL both generate an error.)
--
Mike Nolan