create table inventoryItem (
itemNum varchar2(15) not null,
code varchar2(15) not null,
qtyInstock integer not null,
itemColor varchar2(15),
itemSize integer);
/
insert into inventoryItem (itemNum, code, qtyInstock, itemColor, itemSize)
select 'B3', 'pbk', 30, 'black', 3 from dual union all
select 'W4', 'hbk', 50, 'white', 4 from dual union all
select 'G4', 'hbk', 25, 'green', 4 from dual union all
select 'B3', 'hbk', 20, 'black', 3 from dual union all
select 'B4', 'ebk', 70, 'black', 4 from dual union all
select 'B2', 'pbk', 30, 'black', 2 from dual union all
select 'G3', 'pbk', 50, 'green', 3 from dual union all
select 'G4', 'ebk', 15, 'green', 4 from dual union all
select 'B3', 'pbk', 30, 'black', 3 from dual;
/
select itemNum
, itemSize
, itemColor
, sum(qtyInstock ) as stock_combination
from inventoryItem
GROUP BY itemNum,
itemSize, itemColor;
order by itemNum,
itemSize, itemColor;
ITEMNUM ITEMSIZE ITEMCOLOR STOCK_COMBINATION
G4 4 green 40
B2 2 black 30
G3 3 green 50
B4 4 black 70
W4 4 white 50
B3 3 black 80