public function getPointsByQuiz(Quiz $quiz) { return $this->getEntityManager()->createQuery('SELECT SUM(answer.points) FROM AppBundle:Answer answer INNER JOIN answer.question question INNER JOIN question.quiz quiz WHERE quiz.id=' . $quiz->getId())->getResult()[0][1]; }