SELECT
	SUM(CallCount) AS Total,
	SUM(SuccessCallCount + ErroOsCorte) As TotalSuccess,
	cast(SUM(SuccessCallCount) as decimal) / SUM(CallCount) As SuccessRate,
	SUM(AbandonedCallCount) As TotalAbandon,
	cast(sum(AbandonedCallCount) as decimal) / SUM(CallCount) As AbandonRate,
	SUM(ErrorCallCount + FatalErrorCallCount + InvalidInputCount + ErroSAP + ErroInvClientIdent) As TotalError,
	SUM(TransferedSapError + InvalidClientIdentCount + TransfInvalidInputCount) As TotalTransfered,
	SUM(TransferedOk + TransferedCutOrder) AS TotalIvrTransfered,
	Avg(Duration) As DurationAvg,
	Max(Duration) As DurationMax,
	Min(Duration) As DurationMin,
SUM(univocCPE) as univocCPE,
	SUM(univocNIF) as univocNIF,
	SUM(univocCUI) as univocCUI,
SUM(TransferOLD) as TransferOLD,
SUM(InitialMenu) as InitialMenu,
	SUM(Duration)/Cast(3600 as decimal) AS TotalDuration
 FROM dbo.ComercialCallVolumetryViewMLivre_NumeroVerde