9.1 How to Calculate the Target Amount

The following query is a suggested way of arriving at these target amounts:

select t.JRSDCN_CD,(t.AVG_AMT + 2*t.SD) as min_amt,(t.AVG_AMT + 5* t.SD) as max_amt from /*Consider mean of deposit and withdrawal amounts rather than just one or the other. */ (select JRSDCN_CD, AVG((TOT_DEPST_AM+TOT_WDRWL_AMT)/2) as avg_amt, STDDEV((TOT_DEPST_AM+TOT_WDRWL_AMT)/2) as sd from CUST a inner join CUST_SMRY_MNTH b on a.CUST_INTRL_ID = b.CUST_INTRL_ID /*Choose an appropriate time frame */ where MNTH_SMRY_START_DT between '01-MAY-15' and '01-SEP-15' /* This assumes JURSDCN_CD = Segment. if not adjust appropriately */ group by JRSDCN_CD) t;