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;