gistfile1.rbx

class Article < ActiveRecord::Base
  named_scope :with_total_articles_published,
    :select => 'articles.*, COUNT(*) AS total_articles_published',
    :group => 'user_id'
end

Article.with_total_articles_published.each do |aggregate_article|
  puts "User #{aggregate_article.user_id} has published" \
  " #{pluralize(aggregate_article.total_articles_published, 'article')}"
end