with
  tbl (descr, tqty, dqty, ddate) as (
    select 'WHITE LED DCO', 624,  324, to_date('30-NOV-23', 'DD-MON-RR') from dual union all
    select 'WHITE LED DCO', 550,   20, to_date('01-DEC-23', 'DD-MON-RR') from dual union all
    select 'WHITE LED DCO', 530,    1, to_date('02-DEC-23', 'DD-MON-RR') from dual union all
    select 'WHITE LED DCO', 530, null, to_date('03-DEC-23', 'DD-MON-RR') from dual union all
    select 'WHITE LED DCO', 530, null, to_date('04-DEC-23', 'DD-MON-RR') from dual
  )
select descr, min(ddate) as first_date, 
       min(tqty) keep (dense_rank first order by ddate) as first_tqty,
       sum(dqty) as sum_dqty
from   tbl
group  by descr
;



DESCR          FIRST_DATE  FIRST_TQTY    SUM_DQTY
-------------  ----------  ----------  ----------
WHITE LED DCO  30-NOV-23          624         345

with tbl(descr,tqty,dqty,ddate)
 as (
     select 'WHITE LED DCO',624, 324,date '2023-11-30' from dual union all
     select 'WHITE LED DCO',550,  20,date '2023-12-01' from dual union all
     select 'WHITE LED DCO',530,   1,date '2023-12-02' from dual union all
     select 'WHITE LED DCO',530,null,date '2023-12-03' from dual union all
     select 'WHITE LED DCO',530,null,date '2023-12-04' from dual
    )
select  descr,
        first_date,
        first_tqty,
        sum_dqty
  from  tbl
  match_recognize(
                  partition by descr
                  order by ddate
                  measures
                    first(ddate) first_date,
                    first(tqty)  first_tqty,
                    sum(dqty)    sum_dqty
                  pattern(p+)
                  define p as 1 = 1
                 )
/

DESCR         FIRST_DAT FIRST_TQTY   SUM_DQTY
------------- --------- ---------- ----------
WHITE LED DCO 30-NOV-23        624        345

SQL>