I have written some simple SQL that returns results for the last mon th results. I need this same data for a rolling 12 months and an example of what I want returned. Again thanks for any help.

SQL:

SELECT SUM (TRANSACTIONS.TX_AMOUNT)

FROM CLARITY_REPORT.TRANSACTIONS TRANSACTIONS

INNER JOIN

VOCAB.CALENDAR_FULL CALENDAR_FULL

ON (TO_CHAR (TRANSACTIONS.TX_POST_DATE, 'MM/DD/YYYY') =

TO_CHAR (CALENDAR_FULL.DATE_MM_DD_YYYY, 'MM/DD/YYYY'))

WHERE (TRANSACTIONS.TX_POST_DATE >= CALENDAR_FULL.END_DT - 89

AND TRANSACTIONS.TX_POST_DATE <= CALENDAR_FULL.END_DT)

Desired Results:

END_DT 90_DAY_TRANSACTION_AMOUNT

12/31/2011 $60,742,554.35

1/31/2012 $121,460,890.56

2/29/2012 $179,787,261.67

3/31/2012 $184,373,935.77

4/30/2012 $184,040,522.60

5/31/2012 $182,352,585.11

6/30/2012 $180,535,772.74

7/31/2012 $179,692,597.87

8/31/2012 $185,108,106.00

9/30/2012 $188,808,278.08

10/31/2012 $196,545,546.09

11/30/2012 $197,238,207.00