SQL & PL/SQL

Hi,

Under APEX 24.2 I try to create a stacked bar chart. I want a chart counting NOMBRE_ADULTES and a chart counting NOMBRE_ENFANTS. But the selects of the two series give me the same count !

First serie :

select TO_CHAR(trunc(date_reservation,'mm'), 'DD/MM/YYYY') month       , count(VE_RESERVATION.NOMBRE_ADULTES)
     from VE_RESERVATION
    group by trunc(DATE_RESERVATION,'mm') order by 1

Second serie :

select TO_CHAR(trunc(date_reservation,'mm'), 'DD/MM/YYYY') month       , count(VE_RESERVATION.NOMBRE_ENFANTS)
     from VE_RESERVATION
    group by trunc(DATE_RESERVATION,'mm') order by 1

Why does it give me that same results, because in the table they are different ?

Best regards.