Capturing where a donation's amount doesn't match a subscription's amount

monthly_donation_amount_changes.sql

SELECT s.region_id, s.frequency, s.payment_provider, s.payment_method, s.created_at, s.id, s.email, s.amount_in_local, d.amount_in_local, >
FROM subscriptions s
JOIN donations d ON s.id = d.subscription_id
WHERE d.amount_in_local != s.amount_in_local
AND s.created_at > CURRENT_TIMESTAMP - INTERVAL '3 years'
GROUP BY 1,2,3,4,5,6,7,8,9
ORDER BY 1,2,3,4,5
;

-- Some reasons:
-- 1. donor/admin changes amount via Stripe or PayPal
-- 2. for PayPal, billing failed one month, then doubles up the following month
-- 3. when admins increased a monthly donation in Stripe, there is sometimes an extra "pro-rated" payment which makes up for supposed missing revenue coming from the part of the month that has already happened which "should have been" charged at the new amount 
-- 4. for a time, we would round pledges down to the nearest dollar/pound/euro (source PR?)