It seems like this type of aggregation (a group_by) type thing cannot be done natively in Django. Probably best to leave it for now, with the intention to come back to this in the efficiency drive that we will have to do for the coach reports at some point.