issue when MEDIAN and SUM used in combination

Developement team found issue when combining MEDIAM and SUM in the same query.

They have distilled the issue to the below version of the issue. Any advice is greatly appreciated.

create table avg_bug_test(

    case_col    varchar2(11), 

    duration    number(*,0), 

    quarter     varchar2(6), 

    q2h_knum_b   varchar2(10)

  )

;

 

insert into avg_bug_test values('OK',22,'1.2020','AB1234');

insert into avg_bug_test values('OK',39,'1.2020','AB1234');

insert into avg_bug_test values('OK',30,'1.2020','AB1234');

insert into avg_bug_test values('OK',48,'1.2020','AB1234');

commit;

create or replace force view avg_bug_test_vw