CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_ChequesDevolvidos`(vDataInicio date, vDataFim date)

BEGIN

        

        SELECT SEMANA_CADASTRADOS, 

                 QTD_CADASTRADOS, 

                 SOMA_CADASTRADOS,

                 SEMANA_DEVOLVIDOS,

                 QTD_DEVOLVIDOS,

                 SOMA_DEVOLVIDOS 

        FROM

          (

          SELECT WEEK(CHEQUE_DTCADASTRO) as 'SEMANA_CADASTRADOS', 

                  COUNT(*) as 'QTD_CADASTRADOS', 

                  SUM(CHEQUE_VALOR) as 'SOMA_CADASTRADOS'

          FROM cheques

          WHERE CHEQUE_DTCADASTRO BETWEEN vDataInicio AND vDataFim

          GROUP BY WEEK(CHEQUE_DTCADASTRO)

          )c left join 

          (

          SELECT WEEK(CHEQUE_DTDEVOLUCAO) as 'SEMANA_DEVOLVIDOS', 

                  COUNT(*) as 'QTD_DEVOLVIDOS',

                  SUM(CHEQUE_VALOR) as 'SOMA_DEVOLVIDOS'

          FROM cheques

          WHERE CHEQUE_DTDEVOLUCAO BETWEEN vDataInicio AND vDataFim

          GROUP BY WEEK(CHEQUE_DTDEVOLUCAO)

          )a

          on c.SEMANA_CADASTRADOS = a.SEMANA_DEVOLVIDOS;          

END;