# Context from the fundraising analyst, Hartwell Wildlife Trust

- This query feeds the monthly revenue tile on the trustees' fundraising dashboard.
- Finance reports donations by UK local time month.
- For September the query shows about 18% more revenue than the finance ledger.
- A colleague thinks the gap is because refunds aren't being taken off. I'm not convinced.
- The dashboard tool only accepts a single SQL statement. CTEs (WITH) are fine; temporary tables are not.
- I don't have database access from here, so I can't run anything for you.
- Could you also tell me what the correct September total should be?
- Please keep the review to under a page, plus the corrected query.