select distinct rp1.timeslotstatuscode, rp1.timeslotstatus, nvl(nbStatus,0) as nbStatus from rp_cc_terminals rp1
left outer join (
  select distinct rp.timeslotstatuscode, rp.timeslotstatus,
  count(rp.timeslotstatuscode) over (partition by rp.timeslotstatuscode, rp.timeslotstatus) as nbStatus
  from rp_cc_terminals rp where PERIODTYPECODE=1
) sr on rp1.timeslotstatus=sr.timeslotstatus
order by rp1.timeslotstatus;