I have a model, let's call it MyModel. It has four fields:
id (autonumber) Name Grade Person Date
In sql I want to do something the equivalent of:
select name, count(id), count(distinct person)
from
MyModel
where grade>=3
Is there any way do to this purely using Model and not PHQL?