SUM with GROUP BY with doctrine

8. November 2019 Database

$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('tx_pxcdownloads_domain_model_merkzettel');
$queryBuilder->select('file_reference_uid')
    ->addSelectLiteral(
        $queryBuilder->expr()->sum('tx_pxcdownloads_domain_model_merkzettel.stats_downloads', 'downloads')
    )
    ->from('tx_pxcdownloads_domain_model_merkzettel')
    ->groupBy('tx_pxcdownloads_domain_model_merkzettel.file_reference_uid')
    ->orderBy('count', 'desc')
    ->execute()->fetchAll();