Использование линейной регрессии для вычисления будущего взноса на депозит :)
select TO_CHAR (ADD_MONTHS (TO_DATE (ROWNUM, 'mm'), 12), 'MON-YYYY') MONTH,
intercept + (slope * (ROWNUM + 12)) "Estimate Cost"
from DICTIONARY,(
select
REGR_INTERCEPT (SUM (b.amount),TO_CHAR(to_date(b.arcdate,'dd.mm.yyyy'), 'MM')*1) intercept
,REGR_SLOPE (SUM (b.amount),TO_CHAR(to_date(b.arcdate,'dd.mm.yyyy'), 'MM')*1) slope
from (
select '01.01.2010' arcdate, 100000 amount from dual
union
select '12.02.2010' arcdate, 150000 amount from dual
union
select '15.03.2010' arcdate, 50000 amount from dual
) b
group by TO_CHAR(to_date(b.arcdate,'dd.mm.yyyy'), 'MM')*1
) x
WHERE ROWNUM <= 12;
|