Кол-во дней наличия товара : Супермаг Плюс (Супермаг 2000)

select article,
sum (prih) as p,
sum (rash) as r,
sum (k_ost) as ko
 from
(
select
article,

decode (no, 1, quantity, 0) as prih,
decode (no, 2, quantity, 0) as rash,
decode (no, 3, quantity, 0) as k_ost

from (


select 1 as no,
        article,
       quantity
from smspec where doctype in ('WI', 'IW', 'CR')

union all

select 2 as no,
        article,
       quantity
from smspec where doctype ('WO', 'IW', 'CS')

union all

select 3 as no, article,
       sum(q) as quantity
       from (
                select article, quantity as q from smspec where doctype ('WI', 'IW', 'CR')
                   union all
                select article, -quantity as q from smspec where doctype ('WO', 'IW', 'CS')
            )z  group by article

) a

) b group by article

WITH datelist AS
	(SELECT TO_DATE ('01012007', 'DDMMYYYY') fromdate, TO_DATE ('31122007', 'DDMMYYYY') todate
		FROM DUAL)
	 SELECT DAY
		FROM (SELECT fromdate + LEVEL - 1 DAY
			FROM datelist
		CONNECT BY LEVEL <= todate - fromdate + 1)