Here is a sample of the query used for the Revenue Statistics Report:
 
SELECT AD.STATE, SUM(T.PAYMENT_AMOUNT), SUM(T.PAYMENT_COUNT)
FROM   TRANSACTIONS T, ADDRESSES AD, ACCOUNT_ACTIVITIES AA
WHERE  T.SOFT_CREDIT_TYPE IS NULL
      AND T.STS <> 'D'
      AND (T.ACCOUNT_ID = AD.ACCOUNT_ID(+) AND T.ADDRESS_ID = AD.ADDRESS_ID(+))
      AND (T.ACCOUNT_ID = AA.ACCOUNT_ID(+) AND T.ACTIVITY_TYPE = AA.ACTIVITY_TYPE(+))
      AND AD.PREFERRED_ADDRESS(+) = 'Y'
      AND ((T.GIFT_DATE BETWEEN TO_DATE('01-DEC-17', 'DD-MON-RR') AND
      TO_DATE('31-DEC-17 23:59:59', 'DD-MON-RR HH24:MI:SS')))
GROUP  BY AD.STATE
ORDER  BY AD.STATE;

In this example, the following fields/parameters were used in the Report job that constructed the query:
 
Date Type:               Calendar
Date Column:             Gift Date
Date - Range Start:      12/01/17
Date - Range End:        12/31/17
Payments or Pledges:     PY
Break Group 1:           State