 

<!-- select CL.CAR_ID,CL.CAR_LIB, count(CL.CAR_LIB) from CARAC_LIB CL,CARAC C,PROD P   where 
  		CL.CAR_ID=C.CAR_ID AND
		C.PRO_ID=P.PRO_ID AND
		P.PRO_STATUS=1 AND
		 
  		CL.CRT_ID=4  AND CL.CAR_CAR_ID=23    group by CL.CAR_LIB order by CL.CAR_LIB 143,23,4,VIL_ID,0=0,0=0 -->SELECT CL.CAR_ID,CL.CAR_LIB CARLIB,count(CL.CAR_LIB) NB FROM DEPART D, CARAC_LIB CL WHERE D.VIL_ID=CL.CAR_ID 
    AND DEP_DATE>CURRENT_DATE() group by CL.CAR_LIB order by CL.CAR_LIB