Donor Counts two by four ways, with PostgreSQL included

Here is a simple looking donor member counts report I built for a recent client, with the SQL below to demonstrate the logic is not as simple as it might appear (hooray for window functions in SQL!):