Is there an aggregate that will return an arbitrary instance? That is,
not necessarily the max or min, just any one? (Which might perform
better than max or min)
More importantly:
Is there one which will return an arbitrary instance as long as it's not NULL
And even better:
An aggregate which will return the first instance that meets a certain
predicate?