Ответ

egr 27.05.2003 16:39

select name, count(id) as number_of_posts
from table
order by number_of_posts desc
group by name

---