Develop a Postgresql sql query
Budget: $30 – $250 USD
Given a Postgresql table as in the sample attached, write a SQL query that will provide the following for each of the previous 12 months each time it is run:
Month
Number of New Donors This Month
Number of Donors This Month Making Their Second Donation This Month
Number of First Time Donations This Month
Total Amount of First Time Donations This Month
Total Amount of Second Donation This Month
% of Donors Making a Second Donation This Month
Total of All Donations Made By These Donors
Resulting in an output similar to that shown in the second attachment.
Month
Number of New Donors This Month
Number of Donors This Month Making Their Second Donation This Month
Number of First Time Donations This Month
Total Amount of First Time Donations This Month
Total Amount of Second Donation This Month
% of Donors Making a Second Donation This Month
Total of All Donations Made By These Donors
Resulting in an output similar to that shown in the second attachment.