select CODCOLIGADA, CODFILIAL, CODPERLET, CODCURSO, CURSO, CODTURMA, ANO
		,ISNULL(SUM(CASE WHEN MES =  1 THEN SOMA_DEBITO END),0) AS _JAN_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  2 THEN SOMA_DEBITO END),0) AS _FEV_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  3 THEN SOMA_DEBITO END),0) AS _MAR_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  4 THEN SOMA_DEBITO END),0) AS _ABR_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  5 THEN SOMA_DEBITO END),0) AS _MAI_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  6 THEN SOMA_DEBITO END),0) AS _JUN_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  7 THEN SOMA_DEBITO END),0) AS _JUL_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  8 THEN SOMA_DEBITO END),0) AS _AGO_DEBITO
		,ISNULL(SUM(CASE WHEN MES =  9 THEN SOMA_DEBITO END),0) AS _SET_DEBITO
		,ISNULL(SUM(CASE WHEN MES = 10 THEN SOMA_DEBITO END),0) AS _OUT_DEBITO
		,ISNULL(SUM(CASE WHEN MES = 11 THEN SOMA_DEBITO END),0) AS _NOV_DEBITO
		,ISNULL(SUM(CASE WHEN MES = 12 THEN SOMA_DEBITO END),0) AS _DEZ_DEBITO
		,ISNULL(SUM(SOMA_DEBITO),0) AS _TOTAL_DEBITO
from
(
	SELECT FLA.CODCOLIGADA, FLA.CODFILIAL, sp.codperlet, SH.CODCURSO, SH.NOME as CURSO, SM.CODTURMA,  year(DATAVENCIMENTO) ano, month(DATAVENCIMENTO) mes,
			sum(VALORORIGINAL) SOMA_DEBITO
	FROM SALUNO             (NOLOCK) SA
	JOIN SMATRICPL          (NOLOCK) SM  ON SM.CODCOLIGADA   = SA.CODCOLIGADA  AND  SA.RA = SM.RA
	JOIN SPLETIVO           (NOLOCK) SP  ON SP.CODCOLIGADA   = SM.CODCOLIGADA  AND  SP.IDPERLET  = SM.IDPERLET AND SP.CODFILIAL = SM.CODFILIAL
	JOIN FCFO		         (NOLOCK) FC  ON FC.CODCOLIGADA   = SA.CODCOLCFO    AND  FC.CODCFO    = SA.CODCFO
	JOIN PPESSOA            (NOLOCK) PP  ON PP.CODIGO        = SA.CODPESSOA
	JOIN SCONTRATO          (NOLOCK) SC  ON SC.CODCOLIGADA   = SM.CODCOLIGADA  AND  SC.RA  = SM.RA AND SC.IDPERLET = SM.IDPERLET AND SC.IDHABILITACAOFILIAL = SM.IDHABILITACAOFILIAL
	JOIN SHABILITACAOFILIAL (NOLOCK) SHF ON SHF.CODCOLIGADA  = SM.CODCOLIGADA  AND  SHF.IDHABILITACAOFILIAL = SM.IDHABILITACAOFILIAL AND SHF.CODFILIAL = SM.CODFILIAL
	JOIN SHABILITACAO       (NOLOCK) SH  ON SH.CODCOLIGADA   = SHF.CODCOLIGADA AND  SH.CODCURSO = SHF.CODCURSO AND SH.CODHABILITACAO = SHF.CODHABILITACAO
	LEFT JOIN SPARCELA      (NOLOCK) SPA ON SPA.CODCOLIGADA  = SC.CODCOLIGADA  AND SPA.RA = SC.RA AND SPA.CODCONTRATO = SC.CODCONTRATO AND SPA.IDPERLET = SC.IDPERLET
	LEFT JOIN SLAN          (NOLOCK) SLA ON SLA.CODCOLIGADA  = SPA.CODCOLIGADA AND SLA.IDPARCELA = SPA.IDPARCELA
	LEFT JOIN FLAN          (NOLOCK) FLA ON FLA.CODCOLIGADA  = SLA.CODCOLIGADA AND FLA.IDLAN = SLA.IDLAN
	WHERE
		STATUSLAN = 0	AND datediff( dd, DATAVENCIMENTO, GETDATE()) > 0
	and 	-- sp.codperlet = '2016' and
		fla.codfilial = 1
		and  year(DATAVENCIMENTO) = 2016

	GROUP BY FLA.CODCOLIGADA, FLA.CODFILIAL, sp.codperlet, SH.CODCURSO,  SH.NOME, SM.CODTURMA, year(DATAVENCIMENTO), month(DATAVENCIMENTO)
) as x
GROUP BY CODCOLIGADA, CODFILIAL, CODPERLET, CODCURSO, CURSO, CODTURMA, ANO
ORDER BY ANO, CODCOLIGADA, CODFILIAL, CURSO, CODTURMA