1 2 3 4 5 6
|
select date_debut as Début,date_fin as Fin ,emet_iden as Emetteur, RESI_FISC as Resident, ACTI_TYPE as Detention,
count(acti_iden) as Volume FROM (select distinct date_debut ,date_fin,emet_iden,acti_iden ,RESI_FISC,TYPE FROM
( select distinct DATE_DEBUT ,DATE_FIN,EMET_IDEN,VALE_NATU,TYPE_PROD,VALE_IDEN,RESI_FISC,MAX(ACTI_TYPE) AS TYPE,ACTI_IDEN
FROM FACT_CCN WHERE TYPE_CMPT='PHT' AND EMET_IDEN=60 group by DATE_DEBUT ,DATE_FIN,EMET_IDEN,VALE_NATU,TYPE_PROD,
VALE_IDEN,RESI_FISC,ACTI_IDEN ) ) group by date_debut,date_fin,emet_iden ,RESI_FISC, TYPE |