Zapytanie nie sumuje native sql

Chce stworzyć zapytanie w w native sql w doctrine, lecz mam problemy z tym zapytanie nie wyświetla mi Sumowania ?

public function getExpensesByProperty()
  {

    $rsm = new ResultSetMapping;

    $rsm->addEntityResult('User\UserBundle\Entity\User', 'u');
 
    $rsm->addFieldResult('u', 'username', 'username');
    $rsm->addFieldResult('u', 'id', 'id');
    $rsm->addJoinedEntityResult('Property\ManagementBundle\Entity\Owner' , 'o', 'u', 'owners');
    $rsm->addFieldResult('o', 'o_id', 'id');
    $rsm->addFieldResult('o', 'o_name', 'name');
    $rsm->addJoinedEntityResult('Property\ManagementBundle\Entity\Property' , 'p', 'o', 'property');
    $rsm->addFieldResult('p', 'p_id', 'id');
    $rsm->addFieldResult('p', 'p_name', 'name');
    $rsm->addFieldResult('p', 'p_adress', 'adress');
    $rsm->addJoinedEntityResult('Property\ManagementBundle\Entity\Expenses' , 'e', 'p', 'expenses');
    $rsm->addFieldResult('e', 'e_id', 'id');
    $rsm->addFieldResult('e', 'e_name', 'name');
    $rsm->addFieldResult('e', 'e.price', 'price');

           
                $sql = "
            SELECT  u.id,u.username,
            o.id as o_id,o.name as o_name,
            p.id as p_id,p.name as p_name,p.adress as p_adress,
            e.id as e_id,e.name as e_name,SUM(e.price) as SUMA
            FROM users u 
            INNER JOIN owner o ON u.id = o.user_id
            INNER JOIN property p ON o.id=p.owner_id
            LEFT JOIN expenses e ON p.id=e.property_id
            GROUP BY p_id
           ";
            

    $query= $this->_em->createNativeQuery(
      $sql, $rsm
    );   

//    $query->setParameter(1,$User);

    return $query->getArrayResult();

  }
}

Na mój gust powinieneś otrzymać błąd ponieważ w SELECT masz kolumny bez funkcji agregujących których nie ma w GROUP BY.