Users who haven't written any post in the past 30 days.

user.rb

  scope :inactive, lambda {
    ids = User.joins(:posts)
    .select("users.id, max(post.created_at)")
    .group("users.id")
    .having("max(posts.created_at) < ?", [30.days.ago])

    where(id: ids)
  }