I need a scope that counts the children and compares it to another number. Something like this: 

Training\_date.rb

```
scope :not_full, ->{where("subscriptions.count < candidate_limit")}

```

And then call that scope onto a training\_date index. Only i get an unknown column error.