AverageCallTime::getBaseQuery

public function getBaseQuery($startDate, $finishDate, $filterParameters)
{
	$query = StatisticTable::query();
	$query->addSelect('PORTAL_USER_ID');
	$query->addSelect('AVG_CALL_TIME');

	$query->registerRuntimeField(new ExpressionField(
		'AVG_CALL_TIME',
		'avg(%s)',
		['CALL_DURATION']
	));

	$this->addToQueryFilterCase($query, $filterParameters);
	$query->whereBetween('CALL_START_DATE', $startDate, $finishDate);
	$query->addGroup('PORTAL_USER_ID');

	return $query;
}