The group by can not be done with standard API/PostgREST call. So either have to do view/rpc or handle that part after the fact in js code.