Created
March 19, 2025 18:18
-
-
Save pedroinfo/fd1d3f5eff244d2087a7f3d59c267501 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
mr.contrato, | |
mr.dt_inicio_vigencia_contrato AS dt_inicio_mf_receita, | |
mr.vl_receita_total AS receita_mf_receita, | |
mr.competencia AS competencia_mf_receita, | |
mr2.dt_inicio_vigencia_contrato AS dt_inicio_mf_receita_202501, | |
mr2.vl_receita_total AS receita_mf_receita_202501, | |
mr2.competencia AS competencia_mf_receita_202501, | |
CASE | |
WHEN mr.vl_receita_total = mr2.vl_receita_total THEN 'Iguais' | |
ELSE 'Diferentes' | |
END AS comparacao_receita | |
FROM mf_receita mr | |
LEFT JOIN mf_receita_202501 mr2 | |
ON mr.contrato = mr2.contrato | |
AND mr.dt_inicio_vigencia_contrato = mr2.dt_inicio_vigencia_contrato | |
AND mr.competencia = mr2.competencia | |
WHERE mr.vl_receita_total <> mr2.vl_receita_total |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment