如何在表中找到按日期新增到列中的新值？
我有一個表，其中有一列包含客戶的合同編號，但我想進行比較，如果在前一個日期我有 X 個合同，而在當前日期我有一個額外的合同編號，它會描述這些新合約稱為“新合約”，如果前一天的合約在當天的合約欄中消失，則“合約結束”。
我怎麼能這麼做呢？
我的桌子的圖片：
OBS：我的表名稱：“ECCR28”，我想使用的列“CC”是我的合約列，“DATE”表示合約日期
TABLE CSV: `"","AGENCIA","REFERENCIA","CD_PRODUTO","CC","NM_CLIENTE","OPERACAO","VL_LIMITE","VL_UTILIZADO","PC_TAXA","DT_CONTRATO","TP_CONTRATACAO","DT_VENCIMENTO","INDICADOR_SEGURO","DT_VENC_SEG","ST_CONTRATO"
"1","0011",2022-12-07,"0026","011002845-7","WARLEN TANIOS NEMER","01100284570026008","4.000,00","0,00"," 100,00",2015-09-29,"PA",2023-09-08,"S",2023-09-29,"ATIV"
"2","0011",2022-12-07,"0026","011003535-6","EDUARDO RIBEIRO DOS SA","01100353560026001","1.400,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"3","0011",2022-12-07,"0026","011003803-7","LAZARO GOMES DE MOURA","01100380370026002","2.600,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV""49","0011",2022-12-08,"0026","011002845-7","WARLEN TANIOS NEMER","01100284570026008","4.000,00","0,00"," 100,00",2015-09-29,"PA",2023-09-08,"S",2023-09-29,"ATIV"
"50","0011",2022-12-08,"0026","011003535-6","EDUARDO RIBEIRO DOS SA","01100353560026001","1.400,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"51","0011",2022-12-08,"0026","011003803-7","LAZARO GOMES DE MOURA","01100380370026002","2.600,00","0,00"," 100,00",2022-05-03,"AS",2023-05-03,"N",NA,"ATIV"
"52","0011",2022-12-08,"0026","011003988-2","RODRIGO MENNA BARRETO","01100398820026001","1.200,00","1629,75"," 100,00",2020-12-15,"AA",2021-12-14,"N",NA,"VENC"`