Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table customer_quote(
    id integer,
    part_key integer,
    condition_code integer,
    unit_price number,
    qty_quoted int,
    entry_date date
);
insert all
into customer_quote values(1, 1, 1,  100, 1, '01-JAN-2018')
into customer_quote values(2, 1, 1,  200, 1, '02-JAN-2018')
into customer_quote values(3, 1, 2,  400, 1, '03-JAN-2018')
into customer_quote values(4, 2, 1,  800, 1, '04-JAN-2018')
into customer_quote values(5, 1, 1, 1000, 8, '01-JAN-2019')
into customer_quote values(6, 1, 1, 2000, 4, '02-JAN-2019')
into customer_quote values(7, 1, 3, 4000, 2, '03-JAN-2019')
into customer_quote values(8, 2, 1, 8000, 1, '04-JAN-2019')
into customer_quote values(9, 3, 1,   80, 1, '01-JAN-2000')
select 0 from dual;
9 rows affected

select part_key 
    ,  condition_code 
    ,  count(recent) cq_count 
    ,  sum(case when recent = 1 then (unit_price * qty_quoted) end) cq_total 
    ,  sum(case when recent = 1 then qty_quoted end) cq_qty
from (
    select q.* 
        , case when entry_date > add_months(trunc(sysdate),-12) then 1 end recent
        from customer_quote q
    where entry_date > add_months(trunc(sysdate),-24)
) lookup 
group by part_key, condition_code
order by 1, 2


PART_KEY
CONDITION_CODE
CQ_COUNT
CQ_TOTAL
CQ_QTY


1
1
2
16000
12

1
2
0
null
null

1
3
1
8000
2

2
1
1
8000
1