Query Oracle for 12 month moving total (SUM) of data

Query Oracle for 12 month moving total (SUM) of data

I need to run a query on some data that brings back the moving 12 month
total. I've already performed the average function on the data... so now I
just need to loop through and get a moving 12 month period of data and SUM
it up so I can graph it.
Below is the current query i'm issuing but it isn't adding up correctly.
Basically I want to have January of 1996 show the SUM of the prior 12
months averaged data. So January of 1996 would be the sum of January 1995
+ February 1995 .... all the way through December 1995. Then February of
1996 would be the SUM of February 1995 + March 1995 ....
Is this possible using the OVER function in Oracle 11g? Seems like it is
but I'm not getting the right results for some reason.
Here is my current query:
/* Formatted on 9/5/2013 3:20:55 PM (QP5 v5.149.1003.31008) */
SELECT MONTH_DT,
YEAR_DT,
AVERAGE_TOTAL_RAINFALL,
(SUM (AVERAGE_TOTAL_RAINFALL)
OVER (ORDER BY MONTH_DT ROWS BETWEEN 12 PRECEDING AND CURRENT
ROW)) as "12_MONTH_TOTAL"
FROM ( SELECT month_dt,
year_dt,
TRUNC ( (SUM (tsvalue_ms)
/ (SELECT COUNT (FEATURE_ID)
FROM nexrad.springshed_featureid
WHERE springshed_id = 1)), 3)
AS average_total_rainfall
FROM ts_monthly_agg a, nexrad.springshed_featureid b
WHERE a.FEATURE_ID = b.FEATURE_ID AND b.springshed_id = 1
GROUP BY year_dt, month_dt
ORDER BY year_dt, month_dt)
ORDER BY year_dt, month_dt;
Here is a few rows of the sample data and the current way the OVER
function is calculating.
MONTH YEAR AVERAGE 12_MONTH_TOTAL
------------------------------------
1 1995 4.31 4.31
2 1995 1.932 27.473
3 1995 3.733 47.523
4 1995 4.216 44.841
5 1995 3.721 31.573
6 1995 8.379 50.459
7 1995 6.028 102.591
8 1995 7.918 105.076
9 1995 3.516 97.507
10 1995 5.623 74.056
11 1995 1.813 30.904
12 1995 1.881 23.03
1 1996 2.625 6.935
2 1996 1.165 27.459
3 1996 9.374 55.274
4 1996 2.84 45.388
5 1996 2.538 32.714
6 1996 5.952 55.483
7 1996 6.562 102.816
8 1996 8.428 108.123
9 1996 3.364 95.583
10 1996 4.222 72.252
11 1996 0.453 31.116
12 1996 4.968 26.6
Here is a dataset incase that helps.
Thanks so much for any assistance! Josh
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 1995, 4.31);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 1995, 1.932);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 1995, 3.733);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 1995, 4.216);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 1995, 3.721);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 1995, 8.379);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 1995, 6.028);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 1995, 7.918);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 1995, 3.516);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 1995, 5.623);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 1995, 1.813);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 1995, 1.881);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 1996, 2.625);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 1996, 1.165);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 1996, 9.374);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 1996, 2.84);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 1996, 2.538);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 1996, 5.952);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 1996, 6.562);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 1996, 8.428);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 1996, 3.364);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 1996, 4.222);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 1996, 0.453);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 1996, 4.968);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 1997, 2.384);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 1997, 0.903);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 1997, 2.575);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 1997, 4.692);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 1997, 1.786);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 1997, 6.301);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 1997, 6.515);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 1997, 5.053);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 1997, 5.01);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 1997, 7.267);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 1997, 4.254);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 1997, 8.082);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 1998, 3.205);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 1998, 10.933);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 1998, 4.298);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 1998, 0.385);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 1998, 1.037);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 1998, 2.544);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 1998, 8.21);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 1998, 6.244);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 1998, 10.461);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 1998, 0.378);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 1998, 1.35);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 1998, 0.969);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 1999, 5.353);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 1999, 1.116);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 1999, 1.749);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 1999, 2.02);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 1999, 2.605);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 1999, 8.07);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 1999, 4.378);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 1999, 7.373);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 1999, 5.294);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 1999, 1.281);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 1999, 1.35);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 1999, 1.279);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2000, 2.217);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2000, 0.862);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2000, 1.45);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2000, 0.698);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2000, 0.205);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2000, 8.584);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2000, 5.381);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2000, 5.288);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2000, 6.026);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2000, 0.241);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2000, 1.398);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2000, 0.814);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2001, 2.005);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2001, 0.953);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2001, 6.8);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2001, 0.648);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2001, 0.484);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2001, 6.337);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2001, 8.872);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2001, 5.446);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2001, 8.764);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2001, 0.532);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2001, 0.842);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2001, 1.388);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2002, 1.179);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2002, 1.623);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2002, 2.293);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2002, 1.397);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2002, 0.928);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2002, 9.158);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2002, 7.98);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2002, 8.007);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2002, 4.902);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2002, 2.282);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2002, 3.611);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2002, 7.606);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2003, 0.172);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2003, 4.871);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2003, 7.315);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2003, 1.408);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2003, 3.083);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2003, 12.093);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2003, 5.617);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2003, 6.838);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2003, 3.103);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2003, 2.773);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2003, 1.191);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2003, 0.658);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2004, 1.769);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2004, 5.733);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2004, 1.565);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2004, 1.688);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2004, 1.694);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2004, 7.389);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2004, 9.441);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2004, 7.223);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2004, 18.424);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2004, 2.368);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2004, 2.131);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2004, 1.699);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2005, 0.958);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2005, 2.1);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2005, 6.085);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2005, 6.194);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2005, 5.947);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2005, 10.413);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2005, 11.105);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2005, 11.823);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2005, 2.737);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2005, 4.933);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2005, 2.659);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2005, 4.525);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2006, 1.48);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2006, 6.679);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2006, 0.261);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2006, 2.652);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2006, 2.194);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2006, 6.536);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2006, 7.587);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2006, 8.422);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2006, 5.141);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2006, 1.583);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2006, 1.845);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2006, 4.588);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2007, 3.543);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2007, 5.29);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2007, 2.623);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2007, 1.931);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2007, 1.404);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2007, 5.479);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2007, 10.63);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2007, 5.385);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2007, 6.448);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2007, 6.419);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2007, 0.845);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2007, 2.127);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2008, 3.357);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2008, 4.253);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2008, 5.22);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2008, 2.192);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2008, 0.541);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2008, 8.029);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2008, 9.963);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2008, 13.26);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2008, 2.199);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2008, 1.179);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2008, 1.49);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2008, 0.69);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2009, 3.007);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2009, 1.456);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2009, 1.693);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2009, 2.359);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2009, 10.714);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2009, 5.592);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2009, 8.076);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2009, 5.85);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2009, 4.032);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2009, 1.501);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2009, 3.027);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2009, 2.909);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2010, 3.812);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2010, 5.226);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2010, 6.655);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2010, 1.09);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2010, 5.203);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2010, 5.846);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2010, 6.793);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2010, 9.743);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2010, 2.599);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2010, 0.01);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2010, 0.94);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2010, 0.677);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2011, 4.928);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2011, 2.23);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2011, 3.986);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2011, 2.12);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2011, 2.214);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2011, 5.476);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(7, 2011, 5.713);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(8, 2011, 6.706);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(9, 2011, 4.058);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(10, 2011, 5.27);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(11, 2011, 1.17);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2011, 0.363);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2012, 1.034);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2012, 2.375);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2012, 2.148);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2012, 1.658);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2012, 5.773);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(6, 2012, 14.215);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(12, 2012, 3.889);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(1, 2013, 0.302);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(2, 2013, 1.954);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(3, 2013, 0.781);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(4, 2013, 3.163);
Insert into RAINFALL_DATA
(MONTH_DT, YEAR_DT, AVERAGE_TOTAL_RAINFALL)
Values
(5, 2013, 2.385);