moozi

-- 오라클문법 with table1 as (select distinct t1.year, goods.name from ( select a.year, a.name, sum(ea) as count from (select to_char(orders.orderdate,'YYYY') year, goods.name, ordersDetail.ea from orders join ordersDetail on orders.ono=ordersDetail.ono join goods on ordersDetail.gno=goods.gno) a group by a.year, a.name order by a.year, a.name) t1 cross join goods order by t1.year, goods.name), table..