Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER


Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE 11.2.0.2.0 Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production


create table products (id primary key, name) as
    select rownum, trim (column_value)
    from xmlTable ('"prod1","prod2","prod3"')
3 rows affected

create table contracts (id primary key, prodid, startdate, total) as
    select rownum, mod (rownum, 3)+1, date'2021-01-01'+rownum-1, 100
    from dual connect by level<=180
180 rows affected

select name, coalesce ("'Q1'", 0) "Q1", coalesce ("'Q2'", 0) "Q2" 
from (
    select p.id, p.name, 'Q'||to_char (c.startdate, 'Q') quarter, sum (c.total) total
    from products p 
    join contracts c on c.prodid = p.id
    group by p.id, p.name, to_char (c.startdate, 'Q'))
pivot (sum (total) for quarter in ('Q1','Q2'))


NAME
Q1
Q2


prod1
3000
3000

prod2
3000
3000

prod3
3000
3000