1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| SELECT
(CURRENT_DATE-i) AS DATE_COMPTAGE,
count (distinct(IDNT_COMP_SERV)) AS NB_CLIENTS
FROM RA_PRD.RS_CCO_FD_CC_ACQUI_V_DET
WHERE IDNT_COMP_SERV NOT IN
(
SELECT IDNT_COMP_SERV
FROM RA_PRD.SO_CCO_FD_HIST_OFFR_COMP_SERV
WHERE IDNT_OFFR in (11505,12800,12799,12782)
AND DAT_HEUR_FIN_OFFR_CDS (date) >= (CURRENT_DATE-i-1)
AND DAT_HEUR_DEBT_OFFR_CDS (date) between CURRENT_DATE-i and CURRENT_DATE-i-1
)
AND DAT_ACQ_CDS (date) =(CURRENT_DATE -i)
AND IDNT_OFFR_BSE_ACQ in (812,813,815,943,944,6242,6245,6248,6250,6254,6258,6262);
i va varier de (i = 1 to 90) |
Partager