DoGood Donor team requested data for the following queries.Write SQL statements to perform the following tasks:
List each donor who is from Norfolk, VA. Include first name,last name, pledge date, and pledge amount.
List each month in year 2012 and the total amount of pledgepayments made in that month. Display the month name, year and thetotal amount.
Find out the project, which had the highest number of creditcard payments. Display the project id, name, project fund goal andthe number of credit card pledge payments. (Hint: Use cc for thecredit card pledge payment type.)
Display the donors who have made more than one pledge. Includethe
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured