What is the best way to sort posts in Rails?

Question

Ruby on Rails

How can a scope be written to sort users who have created posts?
user has_many :posts
post belongs_to :user

Answer 1

scope :with_posts, -> { where('EXISTS (SELECT 1 FROM posts WHERE users.id = posts.user_id)') }